Siebel Tools Reference > Adding Custom Extensions to the Data Model > Updating the Logical Schema Definition in the Local Environment >

Deleting Extension Tables or Columns

If you have created an extension table or column that is no longer required, you can delete it from the logical schema. You can delete only custom extension columns and tables; you cannot delete any standard tables or their columns.

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.

To delete a mapping, navigate to the Attribute Mapping object in the Object List Editor and select Edit > Delete Record. To deactivate a mapping, set the Inactive property to TRUE for the Attribute Mapping object definition.

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.

Extension tables or columns that are deleted are removed from the logical schema. If you delete an extension table, the corresponding temporary columns in any interface table that is imported to the base table for the extension table are not deleted. These columns cannot be deleted through Siebel Tools, and will remain in the logical and physical schema.

After you have deleted an extension table or column from the logical schema in the Siebel repository, the table or column still exists in the physical schema of the database. You must apply your changes to the physical database by clicking the Apply button. This will synchronize the logical and physical schemes, dropping any tables or columns from the database that you have deleted from the repository. See Applying the Physical Schema Extensions to the Local Database for more information.

NOTE:  In some database platforms, such as DB2, dropping a column requires you to reconstruct the entire table. However, if there is an object based on the table, a DB2 object such as a view for example, you cannot drop the table from the database.


 Siebel Tools Reference
 Published: 20 October 2003