Answer Posted / reva ram sahu
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 ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can a rule be bound to any column of any data type?
How do clustered indexes store data?
Explain about builtinadministrator?
What is db stored procedure?
What is the default port for SQL Server over a firewall?
What is the index requirement in SQL Azure?
Explain different forms of normalization?
What is the function of sql server agent windows service?
System variable and temporary variables
Why do we use functions?
What is the difference between functions and scalar functions?
What is the library index called?
Can sql servers link to other servers like oracle?
What is the maximum length of an alert name?
How do you migrate data from mssql server to azure?