Hi- One thing that is puzzling me is the contstraint below that isnt a column constraint. constraint ::=PRIMARY KEY ( name [, name]* ) [ conflict-clause ]| UNIQUE ( name [, name]* ) [ conflict-clause ] | CHECK ( expr ) [ conflict-clause ]
if they already have these constraints at the column level, why do they need them a second time as in ... name [type] [[CONSTRAINT name] column-constraint]* the column constraint seems more straight forward column-constraint ::=NOT NULL [ conflict-clause ] | PRIMARY KEY [sort-order] [ conflict-clause ] | UNIQUE [ conflict-clause ] | CHECK ( expr ) [ conflict-clause ] | DEFAULT value please let me know. thanks, marvin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
