Several options are available for deleting an individual column, or several columns in bulk. To delete more than one column in one step, select the columns in the Online Browser or Design Editor while keeping the Ctrl key pressed (Ctrl-Click).
To delete a column from a table:
|1.||Do one of the following:|
|•||In the Online Browser, right-click a column and choose Delete from the context menu or press Del.|
|•||In the Design Editor, right-click and choose Delete selected Columns from the context menu or press Shift+Del.|
A change script is generated and the column is marked for deletion .
|•||In the Online Browser, right-click a column and select Show in new SQL Editor | Drop from the context menu.|
A DROP statement is generated in a new SQL Editor window.
|2.||Depending on your choice in step 1, do one of the following:|
|•||In the Database Structure Change Script window, click the Execute Change Script button.|
|•||In the SQL Editor, click the Execute button or press F5.|
© 2019 Altova GmbH