what is Constraint? How many types of constraints in SQL ?
Answer Posted / sivanagireddy.k
constraints nothing but condition on column in the table by using constraint checking process or validation pprocess has been done.
constraints are 6 tyes
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key
types of level in constraints
column level
table level
send ur queries to this mail id rsivanagireddy@gmail.com
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can truncate be rolled back?
What is a cursor, index in sql?
Where are stored procedures in sql server?
What is the difference between stored procedure and user defined functions?
What are the fixed server level roles? : sql server security
Can binary strings be converted into numeric or float data types?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is difference between unique and primary key?
List out the differences between the clustered index and non-clustered index in sql server?
What do you understand by the denormalisation?
How to create median function?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What do you understand by hotfixes and patches in sql server?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is scrollable cursor?