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