Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 88281 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
Can I save my report as html, excel or word? : sql server management studio
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Can we store videos inside the sql server table?
What are the advantages of the mirroring?
What is normalization according to you and explain its different levels?
Give an example of why you would want to denormalize a database
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Can sub report data source be different from that of the parent report?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is 3nf normalization form?
What are the new security features added in sql server 2012? : sql server security
Which are the olap features?
What is ssrs?
What functions can a view be used to performed?
How do you clear a log file?
