select * from sysindexes

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

Question Posted / srao

Answer Posted / srao

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What do you mean by an execution plan? How would you view it?

871

What is sql server 2000 work load governor?

978

How do you clear a log file?

985

What is indexing a document?

970

How does index makes search faster?

922

How does stuff differ from the replace function?

960

Define views.

962

What is a transactions?

973

Name 3 ways to get an accurate count of the number of records in a table?

968

how you can deploy an ssrs report?

172

Tell me what is the difference between locking and multi-versioning?

972

What are “lock” hints?

999

Explain how would you store your query in an SSRS report or a Database server?

114

What were the latest updates to SQL Azure service?

109

How to find table changes in sql server?

1053