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.

grd_db_table_editor_002

 

Click the Delete Column button

btn_db_table_delete_col_001

 

 

A Confirmation Dialog is shown:

Choose:

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.