what is Constraint? How many types of constraints in SQL ?
Answer Posted / seshu
constraint is a mechanism it is used to prevent the invalid
data entry in to the table is called constraint.
constraints are 5 types they are,
1 Primary Key Constraint
2 Foreign Key Constraint
3 Unique Constraint
4 Not Null Constraint
5 Check Constraint
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Why do we use stored procedures in sql server?
Explain the various types of concurrency problem?
What is use of except clause? How it differs from not in clause?
why would you call update statistics? : Sql server database administration
what types of replication are supported in sql server? : Sql server database administration
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Is it true, that there is no difference between a rule and a check constraint?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is a view in sql?
Show Practically Sql Server Views are updatable?
What is a View ? Can we insert, Update and delete a view?
Which autogrowth database setting is good?
What is the largest component inside a field?
How the authentication mode can be changed?
What is similarity and difference between truncate and delete in sql?