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


Double click a column in the grid




The Column properties dialog is shown:


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.