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
What is a fan-out query in SQL Azure?
What is in place upgrade in sql server?
What are the parts of a function?
What are date and time data types in ms sql server?
How to create an index on an existing table in ms sql server?
What are the 7 disadvantages to a manual system?
What is it unwise to create wide clustered index keys?
Explain difference between control flow and data flow?
What are the tool windows in sql server management studio? : sql server management studio
What is the difference between Normalization and De-normalization?
What is user-defined inline table-valued function?
List some major differences between triggers and stored procedures?
What does nvl stand for?
What is triggers and stored procedures?
Explain sub-query?