what is Constraint? How many types of constraints in SQL ?
Answer Posted / pandia 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 column
(s). Constraints are used to enforce the data integrity.
This ensures the accuracy and reliability of the data in
the database
CONSTRAINT=The threat or use of force to prevent, restrict,
or dictate the action or thought of others.
there are 7 types of constraints are there and they are
grouped in to 4 types. They are
TYPES GROUP
1.DEFAULT = DOMAIN INTEGRITY
2.NOT NULL = DOMAIN INTEGRITY
3.CHECK = DOMAIN INTEGRITY
4.FOREIGN KEY = REFERENTIAL INTEGRITY
5.UNIQUE KEY = ENTITY INTEGRITY
6.PRIMARY KEY = DOMAIN INTEGRITY
7.RULE = USER DEFINED INTEGRITY
Is This Answer Correct ? | 8 Yes | 10 No |
Post New Answer View All Answers
What is the difference between dbcc indexdefrag and dbcc reindex?
When to use null data driven subscription?
What is blocking and how would you troubleshoot it? : sql server database administration
How to add a new dsn with the odbc driver for sql server?
Write down the syntax and an example for create, rename and delete index?
How to delete duplicate rows?
what is difference between view and Dip.
How much memory that we are using in Logshipping Concept?
How to update muliple row in single query?
What is report server project?
How many tables can be joined in SQL Server?
What number aggregate functions are accessible there in sql?
What is an expensive query?
What is read uncmmited?
What does it mean to invest in the index?