# tableLevelConstraint

    [ CONSTRAINT constraintName ]
    {
        CHECK ( searchCondition ) |
        {
            PRIMARY KEY ( simpleColumnName [ , simpleColumnName ]* ) |
            UNIQUE ( simpleColumnName [ , simpleColumnName ]* ) |
            FOREIGN KEY ( simpleColumnName [ , simpleColumnName ]* )
                REFERENCES clause
        }
    } [ constraintCharacteristics ]

A searchCondition is any boolean expression that meets the requirements specified in Requirements for search conditions.

If a constraintName is not specified, Derby generates a unique constraint name.

Parent topic: CONSTRAINT clause
Related reference
columnLevelConstraint
REFERENCES clause
constraintCharacteristics