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 would use the CONNXSCHEMA system tables to determine the SQL statement metadata.  

 

All of the schema tables can also be accessed using INFORMATION_SCHEMA.<schema table name>

 

Example: An application which wants to know the total length of a column so they would know how big to make a text box would issue a call similar to:

Select * from CONNXSCHEMA.dbo.COLUMNS where columnname='CUSTOMERNAME'.

or

Select * from INFORMATION_SCHEMA.COLUMNS where columnname='CUSTOMERNAME'.

 

 

Below 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

 

If you want 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 table's contents.