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
How do I clean up sql server transaction log?
Indexes are updated automatically is the full-text index also updated automatically?
Why transaction is important?
What is database replication?
Explain about integration services of Microsoft SQL server?
what is create database syntax? : Sql server database administration
What are the instances when triggers are appropriate?
What are date and time data types in ms sql server?
Differentiate between sql temp table vs table variable?
Explain logical operators in sql server?
Why truncate is ddl command?
Can we install sql server 2016 on windows 7?
What is parameterized reports in ssrs ?
Explain what is “asynchronous” communication in sql server service broker?
Explain sub-query?