> IDENTITY fields in MS SQL (and Sybase, for that matter) are very simple: > there can be only one IDENTITY field per table, and every INSERT is > guaranteed to generate a unique value for that field.
Yes, well you see that was my understanding also. My reading of that statement is that the identity column *on its own* is a unique key of the table (whether theres a UNIQUE constraint or not). So a primary key constraint that includes an identity column is actually an *error* in the relational model. The other columns are redundant. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
