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

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

Why use identity in sql server?

0 Answers  


What are constraints?

0 Answers  


Explain trigger and its types?

0 Answers  


How to create an multi-statement table-valued function?

0 Answers  


How to test values returned by a subquery with the in operator?

0 Answers  






How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,


What are the fixed server level roles? : sql server security

0 Answers  


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  


can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  


What is the return type of executeupdate ()?

0 Answers  


what is unique and xaml nonclustered index

0 Answers  


What is raid? : SQL Server Architecture

0 Answers  


Categories