Manually Creating a One-to-One Extension Table
You can manually create a one-to-one extension table, but it is recommended that you use the New Table Wizard. For more information, see Guidelines for Creating a Custom One-to-One Extension Table and Using the New Table Wizard to Create a New Table.
To manually create a one-to-one extension table
-
In Siebel Tools, in the Object Explorer, click Table.
-
In the Tables list, locate the base table where you must create an extension table.
-
Verify that the Type property for the table contains Data (Public).
-
Click Extend.
The Database Extension Designer creates the required predefined columns and predefined indexes, and then Siebel Tools displays the extension table in the Tables list. If necessary, the designer creates temporary columns in an interface table that Siebel Tools imports to the base table for this extension table.
-
Optional. Define more extension columns on the custom extension table.
For more information, see Adding an Extension Column to a Base Table.