Modifying a Custom Extension Table or Column

After you create a custom extension table or column, you can only modify the properties of the table or column. You can rename a column before you apply it to the Siebel Server. After you add the column or apply it to the Siebel Server, you cannot rename the column. Instead, you must deactivate the column and create a replacement extension column.

Be careful if you modify the Physical Type property of a column. Depending on existing data that resides in the column, it might not be possible to do this modification.

Siebel CRM does not support modifying a predefined base table or the columns of a predefined base table. You must not modify the extension tables that come predefined with Siebel CRM. For more information, see How an Extension Table Stores Custom Data.

To modify a custom extension table or column

1. Open Siebel Tools.

2. In the Object Explorer, click Table.

3. Optional. Modify a custom extension column:

   1. In the Tables list, locate the table that contains the extension column you must modify.

      If you are adding a new extension table to the EIM Table Mapping list, then make sure you click Activate to create all the temporary columns that Enterprise Integration Manager (EIM) requires.

   2. In the Object Explorer, click Column.

   3. In the Columns list, locate the extension column you must modify, and then modify the properties.

4. Optional. Rename a custom extension column:

   1. In the Tables list, locate the table you must modify, and then deactivate the unwanted column.

   2. In the Tables list, create a new table column.

   3. Export the data from the old column.

   4. Use ddlsync.ksh to synchronize the logical and physical schema and to import the data.

   5. Delete the column you deactivated.

5. Optional. Modify a custom extension table:

   1. In the Tables list, locate the extension table you must modify.

   2. Modify properties, as you require.