What are constraints? Explain different types of
constraints?
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
How do I create a stored procedure in sql server?
How to create a store procedure with encryption?
What do you understand by sql server agent?
What is the use of partition by in sql server?
query processing
Explain the use of containers in ssis?
How data can be copied from one table to another table?
What are the difference between clustered and a non-clustered index?
How many types of schemas are there?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
how would you improve etl (extract, transform, load) throughput?
Explain log shipping?
Write a program to fetch first 10 records from a file?
What is trigger and different types of Triggers?
How to download and install microsoft .net framework version 2.0?