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


Reply via email to