Changing Columns

Top  Previous  Next

Using the Universal Table Editor you can change columns in tables used in your project.

 

To change a column:

Click the Edit Column button

or

Double click a column in the grid

btn_db_table_edit_col_001


grd_db_table_editor_001

 

The Column properties dialog is shown:
 

 dlg_db_table_col_properties_002

Here you enter:

Field Name: You can change the name for your column - any new name must be different from other columns already in your table

Type: You can change the data type for your column - the list can change depending on your database, consult your data user documentation if you are unsure. changing between incompatible types can result in loss of data.

Size: The maximum length of your data value. If the data type you select is fixed length, as with most numeric types, then this number will show as "0" and you cannot change it.

Required: check this this value is required at all times. If you say required, will not be able to add a row into this table if this value is not provided.  This is equal to "Not Null" in database terms.  If you set this this to Required, and any row in the table already has null values in it, the change will be rejected.

 

 

Warning: Changing table structures can result in loss of data.  The Universal Table Editor, tries to preserve your data BUT, this is may not always be possible for example if you drop (delete) a column, all data in that column will be lost.  Always make sure you have backed up your database before attempting to modify it.