SQL$HELP72.HLB  —  CREATE  TABLE  Arguments  enable-disable-clause
    Allows you to enable or disable all constraints, specified
    constraints, a primary key, or a unique column name, as described
    in the following list. By default, table and column constraints
    added during a create table operation are enabled.

    o  DISABLE ALL CONSTRAINTS

       All table and column constraints for this table are disabled.
       No error is raised if no constraints are defined on the table.

    o  ENABLE ALL CONSTRAINTS

       All and column constraints for this table are enabled. No
       error is raised if no constraints are defined on the table.

    o  DISABLE CONSTRAINT constraint-name

       The named constraint is disabled. The named constraint must be
       a table or column constraint for the table.

    o  ENABLE CONSTRAINT constraint-name

       The named constraint is enabled. The named constraint must be
       a table or column constraint for the table.

    o  DISABLE PRIMARY KEY

       The primary key for the table is disabled.

    o  ENABLE PRIMARY KEY

       The primary key for the table is enabled.

    o  DISABLE UNIQUE (column-name)

       The matching UNIQUE constraint is disabled. The columns listed
       must be columns in the table.

    o  ENABLE UNIQUE (column-name)

       The matching UNIQUE constraint is enabled. The columns listed
       must be columns in the table.
Close Help