what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 83745 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rohit nanda
A constraint is a property assigned to a column or the set
of columns in a table that prevents certain types of
inconsistent data values from being placed in the columns.
There are 4 Types of Constraints.
• Entity Integrity - Primary and Unique
• Domain Integrity - Default, Check and Not Null
• Referential integrity – Foreign Key
• User-Defined Integrity - enforces some specific
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is recompile sql server?
How do I install sql server?
what types of replication are supported in sql server? : Sql server database administration
What is an example of a primary key?
What Are the Main Features of SQL Azure?
What is the bookmark lookup and rid lookup?
What is blocking?
List the ways in which dynamic sql can be executed?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is the Disadvantage of indexed sequential file.
what are the reporting service components in SSRS?
How to use the inserted and deleted pseudo tables?
What is the federation in sql azure?
why would you call update statistics? : Sql server database administration
What is a covered index?
