Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vision.v1
Yak Posting Veteran
72 Posts |
 Posted - 2015-03-05 : 05:09:51
|
| Hi,I am using below script for checking existence of "UNIQUE CONSTRAINT" on a given table and on column but its not working correctly.I think need to do some changes to the below script such that need to check some more scenarios like existance of "UNIQUE constraint"/"UNIQUE INDEX"/"PRIMARY KEY CONSTRAINT" before creating the new UNIQUE constraint can some one assist on the script checking before creating the new "UNIQUE CONSTRAINT".SELECT c.table_name, c.constraint_name, c.constraint_type, k.column_name FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS c JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS k ON c.constraint_schema = k.constraint_schema AND c.constraint_name = k.constraint_name AND c.constraint_type IN ('UNIQUE') WHERE c.table_name = @tableName AND k.column_name = @columnNameThanks,Vision.v1 |
|
|
|
|
|
Check - UNIQUE constraint/UNIQUE INDEX/PRIMARY KEY