CONNX Catalog Support
CONNX fully supports three-part table names: catalogs, schemas, and objects.
The following mappings are automatically returned:
Catalog name = logical database name
Schema name = CONNX owner name (currently "dbo" for database, CONNXDB for views)
Object name = table name (or view name)
Objects can be referenced using the fully qualified ANSI SQL catalog.schema.object syntax. You can also use a single object name, if there is no ambiguity. For example:
SELECT * FROM rms.dbo.customer
The schema name is optional - you can substitute two periods for it. For example:
SELECT * FROM rms..customer
CAUTION:
For an existing CDD, you must select Enable CONNX Database Catalog Support on the Tools/Options menu to take advantage of catalog support. See below for more information. This option is enabled by default for new CDDs.
Microsoft Access supports two-part table names that include only the schema and object name. See
Using CONNX with Microsoft Access for more information regarding the use of two-part table names in Microsoft Access.
To enable CONNX database catalog suppport:
1. Select a CDD in the CONNX Data Dictionary Manager window.
2. Click Tools -> Options.
The CONNX Data Dictionary Globel Configuration Options dialog box appears.
3. Mark the Enable CONNX Database Catalog Support checkbox.
4. Click the OK button.
CAUTION:
You must disable full catalog support if you intend to use single table names.