Deleting Columns

Top  Previous  Next

Using the Universal Table Editor you can delete columns in tables used in your project. This is also referred to as "dropping" columns in database jargon.


To drop a column:

Select a the row in the grid that corresponds to the column you want to delete.  Look for the selected row indicator to know which row is selected.



Click the Delete Column button




A Confirmation Dialog is shown:


Yes : if you are sure you want to DROP the column.

No: : if you want to KEEP your column



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.