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 |
|
suman.reddy39
Starting Member
34 Posts |
 Posted - 2008-01-31 : 01:49:53
|
| select constraint_name,constraint_type,table_name 2 from user_constraints 3 where table_name = '&table_name';If I write this Syntax ill get all the key's assigned to this perticular table,But if i want to know for which column what type of key's are assigned then how?SumanReddy.k |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-31 : 02:40:12
|
| try using:-SELECT * FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE WHERE TABLE_NAME='YourTable' |
 |
|
|
|
|
|
constraints