What are constraints? Explain different types of
constraints?
- 26 Answers
- 134055 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
Answer Posted / haritha
constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.
| Is This Answer Correct ? | 283 Yes | 70 No |
Post New Answer View All Answers
Explain rdbms?
How many types of local tables are there in sql server?
Explain the properties of the relational tables?
Which are the new data types introduced in sql server 2008?
What is query cost in sql server?
When is update_statistics command used?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Why it is recommended to avoid referencing a floating point column in the where clause?
Why use triggers?
What gets stored inside msdb database?
Which Model uses the SET concept
How to connect a database with sql express.?
Explain the relational database management system (rdbms)?
How many types of triggers in sql server?
How to include text values in sql statements?
