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
How to create a simple stored procedure in ms sql server?
How do I view a trc file?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Which data type columns are the best candidates for full-text indexing?
What are the joins in sql server? : sql server database administration
What is dimension table? : sql server analysis services, ssas
What do you mean by table and field in sql?
What is difference between equi join and natural join?
Why are views required in the sql server or in any other database?
What is forward - only cursors / read only cursor?
What are the triggers in sql?
How to create a dynamic cursor with the dynamic option?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is the boxing and unboxing concept in .net?