select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where constraint

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

Question Posted / rama krishna

Answer Posted / rama krishna

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

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Different types of keys in SQL?

1082

what method you can use to reduce the overhead of Reporting Services data sources?

253

Is truncate autocommit?

925

What is nolock?

960

How to get the definition of a trigger back?

989

What is the filtered index?

1026

How do clustered indexes store data?

1086

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

994

Do you know sql server 2008 introduces automatic auditing?

958

What is ms sql server triggers?

990

What is the use of tempdb? What values does it hold?

1049

Is it ok to shrink transaction log?

978

What is indexing explain it with an example?

991

What is oltp (online transaction processing)?

982

What happens to a trigger with multiple affected rows?

916