About the New Imported Table Definition
After the table definition is imported using the External Table Schema Import Wizard, the external table and the external column names are generated.
The external table name is stored in the Table object’s Alias property. This external table name consists of the following:
An
EX
prefix (for external table)A three-digit batch code specified in the External Table Schema Import Wizard
An automatically generated seven-digit number
An example of the Table name is EX_ABC_0000001
.
The external column name is stored in the Column child object’s
Alias property. An X
is added as the prefix and a
four-digit number is added as the suffix for the external column name,
for example, X_ABC_0000001_0001
.
The Table object’s Type property is set to External or External View (if a view was imported). This column denotes that the table resides outside of the Siebel database.