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
Do you know clustered and non-clustered index?
what's the maximum size of a row? : Sql server database administration
What is triggers in ms sql server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How do I delete a sql server database?
What is a primary key?
What is row-level compre?
How can you tell if a database object is invalid?
What is an example of a primary key?
What does it mean to be in union?
What is the difference between cartesian product and cross join?
How to generate create procedure script on an existing stored procedure?
Give main differences between "Truncate" and "Delete".
How do I shrink an ldf file?
What are the basic functions for master, msdb, model, tempdb and resource databases?