Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 139742 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
What are the different types of sub-queries?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
tell me the disaster recovery plan
What is the openxml statement in sql server?
What is GUID in sql server?
What are the rendering extensions of ssrs?
Can I delete event logs?
Explain what is the use of custom fields in report?
What is compression - row-level and page-level compression?
Why are views required in the sql server or in any other database?
How to change the ownership of a schema in ms sql server?
What are data resources?
What are the different types of indexes?
Is the primary key column of a table an index in ms sql server?
What is the recovery model?
