skip to main content
Corticon Server: Data Integration Guide : A closer look at how Corticon relates to Datasources : Fully-qualified table names

Try Corticon Now

Fully-qualified table names

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, Schema, and Table.
For databases that support all three levels of qualification, table names take the form:
Microsoft SQL Server uses all three levels of qualification. For example, PatientRecords.dbo.Patient
Others, such as Oracle, do not use Catalog Name, using only schema and table. For example, corticon.Patient. Corticon can infer which levels of qualification are applicable by checking for null values in database metadata.