what is Constraint? How many types of constraints in SQL ?
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
How to remove duplicate rows from table?
What do you mean by a dependent functionality in a build?
Can we perform backup restore operation on tempdb? : sql server database administration
What xml support does the sql server extend?
What are the restrictions applicable while creating views? : SQL Server Architecture
Can select statements be used on views in ms sql server?
Can the query output be sorted by multiple columns in ms sql server?
Which language rdl files made of?
What is the need for indexing?
What is the difference between deallocate cursor and close cursor?
Working with TLogs
What is the contrast amongst drop and truncate?
What is check constraint in sql server?
What is cursors?
How to enforce security in sql server? : sql server security