Schemas
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:
Select * from CONNXSCHEMA.dbo.COLUMNS where columnname='CUSTOMERNAME'.
or
Select * from INFORMATION_SCHEMA.COLUMNS where columnname='CUSTOMERNAME'.
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.