Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 139550 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
Answer Posted / aravindu chowdary
CONSTRAINTS:
*It is a rule (or) restriction ,which is enforced during a
creation of table.
*constraints raises automatically at the time of
inertion,updation,deletion.
*constraints there are 3 types
1.Domain Integrity
* Not null:Donot allow null value.
* check: Limits the range of values or domain, checks
the values which a col can have
2.Entity Integrity
* Unique key:donot allow duplicate values, but allows
one null per col.Can have multiple unique constraints on a
table
* Primary key : Ensure no duplicate data and not allow
nulls.
3.Refrential Intrgrity
*Forgien key:Referntial integrity b/w 2 tables, one
table col values based on other table col values
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How to start and end transact-sql statements?
How to get a list all databases on the sql server?
How do you rename a table in sql server?
What do you mean by table and field in sql?
What is the difference between DATETIME2 and DATETIME?
What is the new security features added in sql server 2014? : sql server security
What are the steps to insert a table?
Can you insert NULL in unique column?
What does asynchronous call backs means?
what is a transaction and what are acid properties? : Sql server database administration
Explain the properties of the relational tables?
What are the different types of data sources in ssrs?
How to return the top 5 rows from a select query in ms sql server?
how can u get last observation in an unknown dataset ?
Difference between connected and disconnected database in .net with sql server?
