How to list all tables having unique constraints in any of
the columns in a database.
Answer Posted / rama krishna
select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where
constraint_type='unique'
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain the concept of view and Types of views in SQL server?
Explain what is meant by replication of database?
Explain concepts of analysis services?
Does partitioning help performance?
what are different types of backups available in sql server? : Sql server database administration
What is rank function?
How to specify the collation for a character data type in ms sql server?
What are different types of roles provided by ssrs?
What programming language would you use to create embedded functions in ssrs?
Explain features of analysis services?
Why I am getting this error when renaming a database in ms sql server?
What is 4nf in normalization form?
What are scheduled tasks in sql server?
How do you send email on SQL Server?
what are the three command line utilities and what are their primary functions?