When you remove a column from a table, you are hiding it from the relational view of your data. You can remove columns directly from the Column Information pane in either the main display or the Schema Tool Native View.
Note: You can hide or remove objects, including columns, from your relational schema in other ways. See Removing Objects from a Schema for details.
Note: Primary key columns cannot be removed from the relational view. To remove the column currently marked as the primary key, you must designate a new primary key before beginning this procedure. For more information, see Designating a Primary Key.
1. Column Information is displayed in either of the following ways:
From the main display, click the table of the column you want to remove.
Navigate to the Schema Tool Native View by clicking the Add Table(s) button
. Then, find the column you want to remove by selecting database and table from the drop-down list.
2. Under Column Information, select the column you want to remove and click the Remove Column button .
3. Click the Save button or select File>Save to save the modified schema.
From the main display, click the table of the column you want to remove.
. Then, find the column you want to remove by selecting database and table from the drop-down list.
.
or select File>Save to save the modified schema.