Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 90841 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rohit nanda
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
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is difference between index and primary key?
What is the need for group functions in sql?
How to create an index on an existing table in ms sql server?
What are scalar functions in sql?
How to find the list of fixed hard drive and free space on server?
How do I find the sql server database version?
What are extended events in sql server?
What is the difference between SQL notification and SQL invalidation?
Delete duplicate rows without using rowid.
How to sort query output in descending order in ms sql server?
How to use "begin ... End" statement structures in ms sql server?
Can you type more than one query in the query editor screen at the same time?
Tell me about the approaches which you used to counter the DI problems.
What do you understand by integration services in sql server?
What are Spatial data types in SQL Server 2008
