Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 90894 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
How to generate create table script on an existing table in ms sql server?
What is the New in SQL server 2008?
Explain go command in sql server?
What are the types of indexing?
Do you know spatial data types - geometry and geography in sql server 2008?
whats new about truncate in sql server 2008?
What is amo? : sql server analysis services, ssas
How to search for a string in all stored procedure in sql server?
Explain throw statement in sql server 2008?
How to implement service broker?
What is database isolation in sql server? : sql server database administration
What is query optimization process?
What are the advantages of passing name-value pairs as parameters?
Does sql server use java?
What are the diifferences between the ms sql server vs mysql?
