Interested to Buy Any Domain ? << Click Here >> for more details...
How to list all tables having unique constraints in any of
the columns in a database.
- 1 Answers
- 4490 Views
- I also Faced
- E-Mail Answers
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 sql injection? How to protect against sql injection attack?
How to get all stored procedures in sql server?
How to drop existing indexes in ms sql server?
Tell me what are the advantages of using stored procedures?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are the differences between DDL, DML and DCL in SQL?
What is the name of reporting services config file and what’s it’s used for?
How to connect to a sql server using odbc_connect()?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
How does clustered and non clustered index work?
What are the events recorded in a transaction log?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What happens if we shrink log file in sql server?
Who developed sql server?
What is it’s similarity with sql server?
