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
What is data compression? : sql server database administration
How do you rebuild an identity column?
What is amo? : sql server analysis services, ssas
Explain about Views?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What are the two authentication modes in sql server?
What are the types of resultset?
What is report snapshot?
How do I create a trace in sql server?
What is a natural primary key?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is ms sql server service broker?
How do you Implement SSIS Packages in your Project?
Explain DBCC?
What is provisioning, billing and metering, and connection routing concepts in the service layer?