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 to sort query output in descending order in ms sql server?
What is oltp (online transaction processing)?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to Check if table exists in sql server?
What is an indexed view?
What is difference between join and natural join?
What is the primary use of the model database?
Which sql server table is used to hold the stored procedure script?
What do you mean by normalisation?
When you should use a low fill factor?
Name few endpoints exposed by ssrs 2012?
How do I manually uninstall an instance of sql server 2016?
What is the difference between sdf and mdf?
Mention what are the different types of ssrs reports?
What is the use of sql profiler in sql server 2012?