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

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1016

What is the process of normalization?

1124

What is implicit mode in sql server?

1105

How can I get data from a database on another server?

995

What are translations and its use? : sql server analysis services, ssas

1040

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

Describe the functionalities that views support.

1099

What is scheduled job and how to create it?

993

How to find the second highest salary of an employee?

1179

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

982

What are database states in ms sql server?

1180

What is the difference between push and pull subscription? : sql server replication

1216

What is the need for indexing?

951

How to attach adventureworkslt physical files to the server?

1106

How to delete duplicate records based on single column from a table?

1050