hi-
I am working on making my program for viewing sql statement results and
changing table structure a little nicer. the reason the question came
about below is I thought I'd like to add capability to have more than
one field be the primary key and also would like to add the constraint
unique to work the same.
if I have a column def statement for every field and specify unique and
primary constraints in each column def, what is the reason the
constraint that goes on the very end of the create table would be needed
[, constraint]* ????
column-def ::= name [type] [[CONSTRAINT name] column-constraint]*
sql-command ::= CREATE [TEMP | TEMPORARY] TABLE table-name (
column-def [, column-def]*
[, constraint]*
)
thank you very much,
jim
