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

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1178

What are Row versions of DataRow?

1015

Can we call future method from trigger?

928

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1119

What does nvl stand for?

938

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1000

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1055

What is repeatable read?

1004

what is a schema in sql server 2005? : Sql server database administration

1014

Describe how to use the linked server?

1133

When should you use an instead of trigger?

948

What are functions in the sql server?

1199

What is the difference between truncate and delete commands?

1057

How many databases can we create in a single server?

207

Which tcl commands are available on the sql server?

1069