1. Configuring Siebel Business Applications
  2. Deleting a Custom Extension Table or Column

Deleting a Custom Extension Table or Column

You can delete from the logical schema a custom extension table or column that you defined. Deleting a table or column removes it from the logical schema in the Siebel repository, but it does not remove it from the physical schema of the Siebel database.

You can only delete a custom extension column or table. You cannot delete a predefined table or the columns of a predefined table.

After you delete an extension table, Siebel Tools does not delete any corresponding temporary columns in an interface table. You cannot use Siebel Tools to delete these columns. The columns will remain in the logical and physical schema.

If a column is empty at the database level, and if the column is in the Siebel repository, and if the column is in the development environment but is not in the production environment, then your database administrator can use a database tool to remove a column that you do not require. The administrator must do a full database backup before removing a column. The administrator must be careful when deleting a column because removing a column that Siebel CRM still references might require the administrator to revert to a full backup.

Using the Siebel Database Configuration Wizard to run the Synchronize Schema Definition (ddlsync) utility does not delete a column that is inactive or that was deleted from the Siebel Repository. For more information, see Siebel Database Upgrade Guide.

To delete a predefined extension column

  1. In the Object Explorer, click Table.

  2. In the Tables list, locate the table that contains the extension column you must delete.

  3. In the Object Explorer, expand the Table tree, and then click Column.

  4. In the Columns list, locate the extension column you must delete.

  5. Click the Edit menu, and then click Delete.

    Siebel Tools does not cascade the deletion of an extension column. You must delete or deactivate the attribute map after you delete an extension column. To delete an attribute map, you can navigate to the Attribute Mappings list in Siebel Tools, and then delete the record.

To delete a predefined extension table

  1. In the Object Explorer, click Table.

  2. In the Tables list, locate the table you must delete.

  3. Click the Edit menu, and then click Delete.