what is Constraint? How many types of constraints in SQL ?
Answer Posted / nivetha sri
Constraint are the certain condition which is used to
limit the data in the table.It can used before creating the
table and after creating the table.
TYPES OF CONSTRAINTS
1] Primary key
2]Foreign key
3]Unique key
4]Check
5]Not Null
6]Default
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the usage of the sign function?
what is a correlated sub-query? : Sql server database administration
Can you tell me about the concept of ER diagrams?
What is the advantage of sql server?
What is encryption key?
can an order by clause be used in a creation of a view?
what is a join? : Sql server database administration
How do you drop an index?
What stored by the tempdb ? : sql server database administration
What does indexation mean?
How can sql server instances be hidden? : sql server security
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Disadvantages of the indexes?
Write an SQL query to obtain the 2nd highest salary.
What are the benefits and tasks of object explorer? : sql server management studio