What are constraints? Explain different types of
constraints?
Answer Posted / ravi gupta
constraint define rules that must be followed to maintain
consistency and correctness of data.a constraint can either
be created while creating a table or can be added later.
constraint can be divided into the following types:--
(1)primary key constraint.
(2)unique constraint.
(3)foreign key constraint.
(4)check constraint.
(5)default constraint.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are locks in sql?
What are the export options of ssrs?
When would you use the stored procedures or functions?
What is the default sql server instance name?
What are the differences between triggers and stored procedures?
what is denormalization and when would you go for it? : Sql server database administration
List out the differences between global and local temp tables in sql server?
What are the differences between sql server and mysql.
Is truncate autocommit?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
How to insert stored procedure result into temporary table?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Will count(column) include columns with null values in its count?
What does it mean to be in union?
How to create dbo table in sql server?