Information Schema

The following tables defined it the SQL2 standard are supported with the indicated caveats:

• Defined but return no rows
  • ASSERTIONS
  • CHARACTER_SETS
  • CHECK_CONSTRAINTS
  • COLLATIONS
  • COLUMN_DOMAIN_USAGE
  • COLUMN_PRIVILEGES
  • CONSTRAINT_TABLE_USAGE
  • CONSTRAINT_COLUMN_USAGE
  • DOMAINS
  • DOMAIN_CONSTRAINTS
  • KEY_COLUMN_USAGE
  • REFERENTIAL_CONSTRAINTS
  • TABLE_CONSTRAINTS
  • TRANSLATIONS
  • USAGE_PRIVILEGES
  • VIEW_COLUMN_USAGE
  • VIEW_TABLE_USAGE

• Implemented as per the SQL2 standard
  • SQL_LANGUAGES
  • INFORMATION_SCHEMA_CATALOG_NAME
  • SCHEMATA
  • TABLES
  • VIEWS
  • TABLE_PRIVILEGES

• Extended information available
  • COLUMNS

• Additional information schema extensions

  SERVER

  Details the database server environment.

  ACTIVE_USERS

  Details all currently connected users.

  ACTIVE_CATALOGS

  Details all currently connected catalogs.

  ACTIVE_SESSIONS

  Details all currently defined sessions.

  USERS

  Details all user authorizations within the catalog.

  USER_PRIVILEGES

  Details all user privileges.

  ROLES

  Details all roles/groups which have been created.

Special considerations

The columns table contains an additional column describing the location of any external text associated with that column. This location is only visible if the file extension is defined in the registry as one which (subject to NT file permissions) users of TextServer may see without explicit grants.