Deleting a Column in a Table

To delete a column in a table

1. In the Object Explorer, select a table you want to edit and choose Edit from the popup menu. The table opens in the new Table Editor document.
2. Right-click the column that you want to delete. Choose Delete from the popup menu.
3. Click Yes to confirm the deletion. The column is removed.
4. Choose Table->Execute to save the table in the database. When you save the table, the deleted column and all the data are removed.

Warning
When columns are deleted that are referenced in an expression distribution scheme, you must:

Change the expressions to remove any references to the deleted column.
1. Edit the fragmentation expression information and remove all the references to the deleted column.