Deleting Columns

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Exploring and Changing the Database Structure > Designing Tables in Design Editor >

Deleting Columns

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 ic_delete-column.

 

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 dbs_ic_execute_script button.
In the SQL Editor, click the Execute dbs_ic_execute_script button or press F5.

© 2019 Altova GmbH