Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 139334 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
Answer Posted / henry
Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null
| Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
How to delete duplicate records based on single column from a table?
How to loop through returning rows?
What is the difference between coalesce() & isnull()?
What is nolock?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is difference between index seek vs. Index scan?
how to avoid cursors? : Sql server database administration
Difference between drill down and drill through report.
What is the use of stored procedure?
What is tempdb database? : SQL Server Architecture
Do you know what are acid properties?
What are the different types of sub-queries?
What is the difference between varchar and varchar(max) datatypes?
What happens when unicode strings concatenate with non-unicode strings?
How to turn on the mssql api module in php?
