How to list all tables having unique constraints in any of
the columns in a database.
Answer / rama krishna
select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where
constraint_type='unique'
| Is This Answer Correct ? | 4 Yes | 0 No |
What is serializable?
What is the difference between distinct clause and group by clause?
What are the joins in sql server? : sql server database administration
Explain about extended stored procedure?
What is store procedure? How do they work? When do you use?
What options are available to audit login activity? : sql server security
What are the functions in sql server?
explain query execution plan
How to download and install sql server 2005 books online?
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
How to install sql server 2005 express edition?
How do I save a stored procedure in sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)