Is there a way to associate IDENTITY columns from two different tables, so that new records created in either table will have mutually unique values?
That is, a new record in table A will be given value 1, and then a new record created in table B will be given value 2 (because value 1 was already used by the IDENTITY column in table A). Can this be done?
No, identity fields are only unique within the table.
No comments:
Post a Comment