Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


CONSTRAINT_TABLE_USAGE


The CONSTRAINT_TABLE_USAGE system view lists the tables on which constraints (referential constraints, unique constraints, check constraints and assertions) that are owned by the current ident are defined.

Column name
Data type
Description
TABLE_CATALOG
VARCHAR(128)
The name of the catalog containing the table.
TABLE_SCHEMA
VARCHAR(128)
The name of the schema containing the table.
TABLE_NAME
VARCHAR(128)
The name of the table.
CONSTRAINT_CATALOG
VARCHAR(128)
The name of the catalog containing the constraint.
CONSTRAINT_SCHEMA
VARCHAR(128)
The name of the schema containing the constraint.
CONSTRAINT_NAME
VARCHAR(128)
The name of the constraint.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX