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
- 4489 Views
- I also Faced
- E-Mail Answers
Answer / rama krishna
select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where
constraint_type='unique'
| Is This Answer Correct ? | 4 Yes | 0 No |
Explain candidate key, alternate key, and composite key?
what is the Enterprise manager(2000) and management studio (2005)?
What is the difference between a local and a global variable?
what is package configuration variable?How to change file name in folder dynamically?Plz help me
how to replace double quotes by single quotes in sql server
how to take backup bcp out for a column in table in sql server?
Can we insert data into view sql server?
Write a program to fetch first 10 records from a file?
How to check if stored procedure is running in sql server?
explain different types of backups avaialabe in sql server? : Sql server database administration
How to insert and update data into a table with "insert" and "update" statements?
How to transfer an existing table from one schema to another schema in ms sql server?
-
Oracle (3259) - 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)
