what is Constraint? How many types of constraints in SQL ?
Answer Posted / mohan
Constraint is nothing but set of rules or restrictions on a column,in order to achieve business requirements.
There are five types of constraints,
they are
1.primary key
2.unique key
3.not null
4.check
5.foreign key
These constraints also called data integrity constraints.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain about local stored procedure?
How to encrypt data between dialogs?
What the different components of Replication and what is their use?
Do you know what is normalization of database? What are its benefits?
How to round a numeric value to a specific precision?
Why use “pivot” in sql server?
what are the important architecture components of SSRS?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is pessimistic concurrency?
What is clustered index
How to see existing views in ms sql server?
mention different types of relationships in the dbms?
What are the different types of collation sensitivity in sql server?
What is PROJECTION Operation?
can you implement data mining in SSRS?