An Information Schema provides metadata about a given database (catalog).

CONNX provides this capability through System Catalog tables in a CONNX CDD. System catalog tables represent the CDD tables/database/columns metadata (which include Information Schema metadata). In CONNX, the System Catalog tables are in a single schema: CONNXSCHEMA.

You can access CONNXSCHEMA (the CONNX Catalog Tables) using SQL Query Statements. Your applications use the CONNXSCHEMA system tables to determine the SQL statement metadata.

You can also access the schema tables using INFORMATION_SCHEMA.schema table name

For example, an application which wants to know the total length of a column in order to determine how big to make a text box, issues the following call:

The following is a list of the CONNXSCHEMA tables:

CONNXSCHEMA.dbo.BASE_TABLES

CONNXSCHEMA.dbo.CLUSTERS

CONNXSCHEMA.dbo.COLUMN_PRIVILEGES

CONNXSCHEMA.dbo.COLUMNS

CONNXSCHEMA.dbo.CONSTRAINT_COLUMN_USAGE

CONNXSCHEMA.dbo.CONSTRAINT_TABLE_USAGE

CONNXSCHEMA.dbo.DATABASES

CONNXSCHEMA.dbo.INFORMATION_SCHEMA_CATALOG_NAME

CONNXSCHEMA.dbo.KEY_COLUMN_USAGE

CONNXSCHEMA.dbo.NOT_NULL_CONSTRAINTS

CONNXSCHEMA.dbo.REFERENTIAL_CONSTRAINTS

CONNXSCHEMA.dbo.SCHEMATA

CONNXSCHEMA.dbo.SERVER_INFO

CONNXSCHEMA.dbo.syscnxColumnPrivleges

CONNXSCHEMA.dbo.syscnxColumns

CONNXSCHEMA.dbo.syscnxForeighKeys

CONNXSCHEMA.dbo.syscnxGetTypeInfo

CONNXSCHEMA.dbo.syscnxPrimaryKeys

CONNXSCHEMA.dbo.syscnxProcedureColumns

CONNXSCHEMA.dbo.syscnxProcedures

CONNXSCHEMA.dbo.syscnxSpecialColumns

CONNXSCHEMA.dbo.syscnxStatistics

CONNXSCHEMA.dbo.syscnxTablePrivileges

CONNXSCHEMA.dbo.syscnxTables

CONNXSCHEMA.dbo.TABLE_CONSTRAINTS

CONNXSCHEMA.dbo.TABLE_INDEXES

CONNXSCHEMA.dbo.TABLE PRIVILEGES

CONNXSCHEMA.dbo.TABLES

CONNXSCHEMA.dbo.USERS

CONNXSCHEMA.dbo.VIEW_COLUMN_USAGE

CONNXSCHEMA.dbo.VIEW_TABLE_USAGE

CONNXSCHEMA.dbo.VIEWS

To see the CONNXSCHEMA tables, go to INFONAUT, and select the checkbox where it asks to see the system tables. This will allow you to view the contents of the table.