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

Do you know what is a trace frag? Where do we use it?

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

What stored by the model? : sql server database administration

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

how you can get the list of largest tables in a database? : Sql server administration

How to delete existing rows in a table?

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

sql database suspect We have a sql database that is showing as suspect. How can we recover?

How do I change my passwords (database, LDAP, and so on) without causing an outage?

What are the different types of queries?

How to verify the port number of the sql server?

What is RAID? What are the different types of RAID configurations?

For more SQL Server Interview Questions Click Here