Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 89706 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
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
What is sql server english query?
What is the difference between varchar and varchar(max) datatypes?
what are constraints? Explain different types of constraints? : Sql server database administration
What are commonly used mssql functions in php?
What do you mean by an execution plan? Why is it used? How would you view it?
can a database be shrunk with users active? : Sql server administration
What is the function of inner join?
What are transactions and its controls?
Mention the different types of replication in sql server.
Can I disable or restrict ssrs export formats (rendering formats)?
Explain what are partitioned views and distributed partitioned views?
How many databases instances are there in sql server 2000?
When is the use of update_statistics command?
how to overcome kernel isssues
What is the concept of optimization?
