how can i have a unique column in many tables

Posted by Behrooz on Stack Overflow See other posts from Stack Overflow or by Behrooz
Published on 2010-03-08T21:09:17Z Indexed on 2010/03/08 21:21 UTC
Read the original article Hit count: 235

hi.
I have ten or more(i don't know) tables that have a column named foo with same datatype.
how can i tell sql that values in all the tables should be unique.
I mean If(i have value "1" in table1) I should NOT be able to have value "1" in table2

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2008