Hi,
I defined a check constraint with following DDL-statement ALTER TABLE <Table-Name> ADD CONSTRAINT <Constraint-Name> CHECK <Column-Name> IN ('Y', 'N') When I controlled the results of the operation in SQL Studio the constraint was set up under the name which was given in the DDL command (also the predicate and the expression), but the association of the constraint to the referred column was missing. Is there something wrong with my DDL? Thank You in advance! Frank Schimmelpfennig PHILIPS Semiconductors Hamburg ATO-PICTOH IT&DataSupport Tel.: +49 40 5613 -1835, Fax: -3020