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 web server?
How do I determine how many instances of sql server are installed on a computer?
What is lock escalation?
how to select a field with firstletter as capital and remaining are small letters
Explain about SQLOS?
What are the advantages of mirroring?
What is a data collection table?
I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.
What is enhanced database mirroring in sql server 2008?
SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES
what does the automatic recovery do? : Sql server administration
Wht is the difference between stored procedure and trigger
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)