Edit the properties of an existing column in a Data Designer table.
Changing the structure of an existing table can cause you to lose data and have a negative effect on applications that rely on the data table.
Implementation:
- Click the
icon in the Activity Bar. - Switch to the Definitions tab.
- Right-click the table containing the column and select Edit Table.
- Double-click the column in the Your New Columns list.
- Make the required changes to the column. You can change the column's name, data type, and default value.
If you change the column's type, the data already contained in the column may not be compatible with the new type and may thus be truncated or invalid.
- Click Update Table to save the changes.