How to list all tables having unique constraints in any of
the columns in a database.



How to list all tables having unique constraints in any of the columns in a database...

Answer / rama krishna

select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where
constraint_type='unique'

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  


when you create a database how is it stored? : Sql server database administration

0 Answers  


How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,


Do you know what are the properties of the relational tables?

0 Answers  






What are the properties and different types of sub-queries?

0 Answers  


Where are sql server usernames and passwords stored in the sql server?

0 Answers  


How to create Clustered Primary Key to table?

2 Answers  


What is partition in sql server?

0 Answers  


List the different types of joins?

0 Answers  


Explain user defined functions?

0 Answers  


Explain the disadvantages of cursors?

0 Answers  


Categories