Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 89712 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
How do I find the default sql server instance?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
Tell me what is log shipping?
What is database black box testing?
How to override dml statements with triggers?
Do you know spatial data types - geometry and geography in sql server 2008?
How to find out what is the default collation in a database?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What are the types of database schema? : sql server analysis services, ssas
How to convert numeric expression data types using the cast() function?
What is the importance of three tier architecture?
How to use old values to define new values in update statements in ms sql server?
What are the database roles? : sql server security
What is the use of keyword with encryption.
What is buffer cash and log cache in sql server?
