Configuring Schemas SECTION 12 Databases
193
12-6-8 Database Schema Types
The Database Schema types supported in ADO are:
Schema Type values Criteria Values
Schema Asserts CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
Schema Catalogs CATALOG_NAME
Schema Character Sets CHARACTER_SET_CATALOG
CHARACTER_SET_SCHEMA
CHARACTER_SET_NAME
Schema Check
Constraints
CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
Schema Collations COLLATION_CATALOG
COLLATION_SCHEMA
COLLATION_NAME
Schema Column Domain
Usage
DOMAIN_CATALOG
DOMAIN_SCHEMA
DOMAIN_NAME
COLUMN_NAME
Schema Column
Privileges
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
GRANTOR
GRANTEE
Schema Columns TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
Schema Constraint
Column Usage
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
Schema Constraint Table
Usage
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME