Whenever table names appear in properties, Corticon uses fully-qualified names; thus, a table name may consist of up to three nodes separated by periods. The JDBC specification allows for up to three levels of qualification for a table name:
Catalog Name
Schema Name
Table Name
For databases that support all three levels of qualification, table names take the form:
<catalog>.<schema>.<table>
Microsoft SQL Server uses all three levels of qualification. For example, Accounting.dbo.Customer
Others, such as Oracle, do not use Catalog Name, and therefore use only schema and table. For example, corticon.Customer
Corticon can infer which levels of qualification are applicable by checking for null values in database metadata. For example, for databases that do not support Catalog Name, that field will be null for all tables.
Catalog Name