How can you list all the table constraints in a database?
No Answer is Posted For this Question
Be the First to Post Answer
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
Do you know what is difference between index seek vs. Index scan?
What are the advantages of using third-party tools?
What is sql server query analyzer?
What is user stored procedure & it purpose?
Define cursor locking
What is the order by used for?
What is constraints and its types?
What are the mathematical functions supported by sql server 2005?
What is analysis service repository?
What is fill factor and pad index?
Can we write a distributed query and get some data which is located on other server and oracle database?
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)