Home Forums SQL Server 2005 SQL Server 2005 General Discussion confusion in setting up superkey RE: confusion in setting up superkey
Andrew G
SSChampion
Points: 12809
More actions
October 15, 2012 at 10:20 am
#1549196
You can create a unique non clustered index on (VENDORID+ADDRESS+CITY) since your primary key is already specified. You can specify a unique key constraint when creating the table also.