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

2 Answers
7420 Views
I also Faced
E-Mail Answers

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

Post New Answer

More SQL Server Interview Questions

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers

What are various limitations of the views?

0 Answers

Explain what are magic tables in sql server?

0 Answers

What is sql server query analyzer?

0 Answers

What is a schema in ms sql server 2005?

0 Answers

What are the new features in sql server 2016?

0 Answers

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?