Does a table constraint name need to be universally unique, unique within
the table, or not unique at all?

By constraint name, I mean pkProduct and fkCategory in the SQL that follow:

CREATE TABLE product
(id  VARCHAR(40),
name VARCHAR(100),
category VARCHAR(40),
...
CONSTRAINT pkProduct PRIMARY KEY (id),
CONSTRAINT fkCategory FOREIGN KEY (category) 
        REFERENCES categroy(id))

-dain


_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to