Configuring Siebel eBusiness Applications > Configuring Tables and Columns >

Deleting Extension Tables or Columns

You can delete extension tables and columns that you have created from the logical schema. Deleting tables and columns removes them from the logical schema in the Siebel repository, however it does not remove them from the physical schema of the database.

NOTE:  You can delete only custom extension columns and tables; you cannot delete any standard tables or their columns.

After you delete an extension table, any corresponding temporary columns in an interface table are not deleted. These columns cannot be deleted through Siebel Tools, and will remain in the logical and physical schema.

To delete an existing extension column

1. Connect to your local development database with Siebel Tools.
2. In the Object Explorer, expand the Table object type.
3. In the Object List Editor, select the table containing the extension column to be deleted.
4. In the Object Explorer, select Column.
5. In the Object List Editor, select the extension column to be deleted.
6. Select Edit > Delete from the menu to delete the extension column.

   NOTE:  Siebel Tools does not cascade the deletion of an extension column. You should delete or inactivate the attribute mapping after deleting the extension column. You can delete mappings by navigating to the Attribute Mapping object in the Object List Editor and select Edit > Delete Record.

To delete an existing extension table

1. Connect to your local development database with Siebel Tools.
2. In the Object Explorer, select the Table object type.
3. In the Object List Editor, select the extension table to delete.
4. Select Edit > Delete from the menu to delete the extension table.