Which system table contains information on constraints on all the tables creat

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

Question Posted / guest

Answers were Sorted based on User's Feedback

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

Answer / priya reddy

user_constraints table will contain the information on
constraints on all the tables created.

Is This Answer Correct ?

10 Yes

1 No

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

Answer / srao

select * from sysindexes

Is This Answer Correct ?

1 Yes

1 No

More SQL Server Interview Questions

what is the difference between table and view

What is stored procedure in SQL..??

How to list all field names in the result set using mssql_field_name()?

How to enter binary string literals in ms sql server?

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

Can a function call a stored procedure in sql server?

What is cube dimension? : sql server analysis services, ssas

What is index, cluster index and nonclustered index?

What is the diff between Dynamic queries and static queries

What is apply operator in sql?

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

For more SQL Server Interview Questions Click Here