Which system table contains information on constraints on
all the tables created?

Answer Posted / srao

select * from sysindexes

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what does the automatic recovery do? : Sql server administration

639


What is nolock?

644


Explain “@@rowcount” and “@@error” in sql server?

625


What are sub reports and how to create them?

103


How do you delete duplicate rows in sql server?

576






You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

122


Tell me something about security and sql azure?

110


How to add a new dsn with the odbc driver for sql server?

644


What is query parameter in ssrs?

122


What stored by the msdb?

681


Mention a few common trace flags used with sql server?

616


Tell me what is difference between view and materialized view?

603


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

642


Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

614


How would you add a section to a table?

669