CREATE TABLE 支持表和列 CHECK 约束的核心功能;CHECK_CONSTRAINTS 表提供有关这些约束的信息。CREATE TABLE supports the core
features of table and column CHECK constraints;
the CHECK_CONSTRAINTS table provides
information about these constraints.
CHECK_CONSTRAINTS 表具有以下列:The CHECK_CONSTRAINTS table has these
columns:
CONSTRAINT_CATALOGCONSTRAINT_CATALOG约束所属的目录名称。该值始终为
def。The name of the catalog to which the constraint belongs. This value is alwaysdef.CONSTRAINT_SCHEMACONSTRAINT_SCHEMA约束所属的模式(数据库)名称。The name of the schema (database) to which the constraint belongs.
CONSTRAINT_NAMECONSTRAINT_NAME约束的名称。The name of the constraint.
CHECK_CLAUSE指定约束条件的表达式。The expression that specifies the constraint condition.