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

Answer Posted / priya reddy

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

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When should you use an instead of trigger?

554


What you can do to delete a table without the delete trigger firing?

521


Explain table valued parameters in sql server? Why tvp used?

559


Explain boyce and codd normal form(bcnf)?

535


What is unpivot?

571






What is the difference between insensitive and scroll cursor?

578


Explain indexing and what are the advantages of it?

531


What is the difference between value type and reference type?

553


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

680


How to include text values in sql statements?

589


What command is used to rename the database?

527


1 01 101 01010

1570


What are the key configuration files for sql server reporting services ?

120


Name few of the dcl commands in sql?

552


How to loop through result set objects using mssql_fetch_array()?

542