what is Constraint? How many types of constraints in SQL ?
Answer Posted / nambi rajan
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
business rules that do not fall into entity, domain, or
referential integrity categories
Is This Answer Correct ? | 13 Yes | 7 No |
Post New Answer View All Answers
How to override dml statements with triggers?
How we can refresh the view?
Explain about protocol layer present in SQL server?
How you provide security to cube? : sql server analysis services, ssas
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Can I delete event logs?
What are the properties of primary key?
What does it mean to be in union?
What the difference between UNION and UNIONALL?
What are the types of processing and explain each? : sql server analysis services, ssas
How will you make an attribute not process? : sql server analysis services, ssas
Which tcp/ip port does sql server run on? How can it be changed?
What are different type of Collation Sensitivity?
How you can find out if an index is useful to the optimizer?
What are types of subqueries?