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. Navigate to the main display. You can access the Column Information pane in one of the following ways:
    • If you want to remove columns for an existing table, click the table of the column you want to remove.
    • If you want to remove columns when extracting a new table, right-click on a table you want to add to your schema under a new name, and select Extract New Table. See "Extracting a new table" for general information on extracting tables.
  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.