1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Post New Answer

More SQL Server Interview Questions

How do I list the available tables in a database I'm querying?

4 Answers  

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

How you can minimize the deadlock situation?

0 Answers  

What are the restrictions while creating batches in sql server?

0 Answers  

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  




Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

What is a covering index?

0 Answers  

What is row by row processing ?

2 Answers  

What are Row versions of DataRow?

0 Answers  

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

How to drop an existing table with "drop table" statements in ms sql server?

0 Answers  

How to check status of stored procedure in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories