what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 83749 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
Show Practically Sql Server Views are updatable?
What are the five characteristics of good data?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is the maximum row of a size?
What is correlated subquery in sql server?
How to delete multiple rows with one delete statement in ms sql server?
How do I open port 1433?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is sharding?
What stored by the master? : sql server database administration
wat wil hapn if we give the both read and deny read permission to user?
What are parameterized reports? What are cascading parameters in ssrs reports?
How to list all tables in the database using odbc_tables()?
How can you insert values in multiple rows using one Insert statement?
