what is Constraint? How many types of constraints in SQL ?
Answer Posted / shelly
Constraints are used to limit the type of data that goes
into a table.Constraints can be declared at the time of
creating a table or by altering the already created table.
1)Not Null
2)Unique
3)Primary Key
4)Check
5)References
6)Default
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is log ldf?
How to scale out a federation by Sql statement?
What do you understand by a view?
Explain trigger and its types?
What is the difference between update lock and exclusive lock?
What is the contrast amongst drop and truncate?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Explain activity monitors
Where to find ntwdblib.dll version 2000.80.194.0?
List some advantages and disadvantages of stored procedure?
How important do you consider cursors or while loops for a transactional database?
What is statement level trigger?
Do you think BCNF is better than 2NF & 3NF? Why?
What is apply operator in sql?