Stay informed about any major changes. Click here to subscribe
Change a column's data type or size
You can use Table Designer to
change existing columns in a table. Before converting from one data type
to another, consider how the change will affect your entire database.
When you select a data type, length is defined automatically. You can
increase or decrease the length property only for a column with a binary
or text data types. For columns with other data types, the length is derived
from the data type and cannot be changed. If the new specified length
is smaller than the original column length, all values in the column that
exceed the new length are truncated without any warning. It is not possible
to change the length of a column defined with a PRIMARY KEY or FOREIGN
KEY constraint.
