what is Constraint? How many types of constraints in SQL ?
Answer Posted / rehan khan
constraint enforces rules at the table level and prevent the deletion of a table if there are dependencies .
constraint type:
primary key
foreign key
unique
not null
null
check
constraints can be defined at the time of table creation or after table has been created.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many types of triggers in sql server?
What happens when the SQL Azure database reaches Max Size?
what is difference between view and Dip.
What is failover clustering overview?
How you can change the database name in SQL SERVER?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
what are the new features in SSRS?
What is clustered index
What is Command line parameters in PLSQL.?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What's new in sql management studio for sql server? : sql server management studio
How to round a numeric value to a specific precision?
Do you know what are various aggregate functions that are available?
When to use Inner join & when to use subquery?
How to insert new line characters into strings?