Bookshelf Home | Contents | Index | Search | PDF

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

Modifying Extension Tables or Columns

---

You may need to modify your extension tables or columns after creating or activating them. You can modify properties of extension tables or columns only. Modification of standard base tables and their columns is not supported. If you delete the custom table, you need to delete the data object as well, if there is any.

To modify an existing extension column

Connect to your local development database with Siebel Tools.
In the Object Explorer, expand the Table object type.
In the Object List Editor, select the table containing the extension column to modify.

NOTE:  If you are adding a new extension table to the EIM Table Mapping list, make sure you click Activate to create all the necessary temporary columns that are needed for EIM processing.

In the Object Explorer, select Column.
In the Object List Editor, select the extension column to modify.
Modify the appropriate properties.

You can rename a column prior to applying it to the server. However, once the column has been added or applied to the server, you cannot simply rename the column and must deactivate the existing column and create a replacement extension column.

To rename an existing extension column

Deactivate the unwanted column.
Create the new column in Siebel Tools (the logical schema).
Export the data from the old column.
Drop the old column.
Use ddlsync.ksh to synchronize the logical and physical schema and import the data back in.

To modify an existing extension table

Connect to your local development database with Siebel Tools.
In the Object Explorer, select the Table object type.
In the Object List Editor, select the extension table to modify.
Modify the appropriate properties.

NOTE:  Be careful when modifying the Physical Type property for columns; depending on existing data in the column, changes may not be possible.

Bookshelf Home | Contents | Index | Search | PDF