Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 90776 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 do use Having,Group by,Group function in SQL?
what's the difference between a primary key and a unique key? : Sql server database administration
What is the recommended total size of your memory optimized tables?
Explain the difference between HTTP and HTTPS in database?
What is mssql?
How to start and end transact-sql statements?
What is sql server query analyzer?
What are the different types of cursor?
Difference between 2NF &3NF ?
what is difference between NULL and ISNULL in SQL Server 2008?
What are the events recorded in a transaction log?
What do you mean by sql server agent?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is the difference between a unique key and primary key?
How do you trace the traffic hitting a sql server?
