what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 83743 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
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
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
What is usually the first word in a sql query?
Explain the difference between HTTP and HTTPS in database?
How to list all user defined functions in the current database?
What are different types of statement?
Why olap is used?
Explain different types of index?
What stored by the msdb?
Describe in brief system database.
What is lock escalation and what is its purpose?
Explain the relational database management system (rdbms)?
What is the order in which the sql query is executed?
Different types of keys in SQL?
What is the difference between a "where" clause and a "having" clause?
What does sql server mean?
