What are constraints? Explain different types of
constraints?
Answer Posted / ravi gupta
constraint define rules that must be followed to maintain
consistency and correctness of data.a constraint can either
be created while creating a table or can be added later.
constraint can be divided into the following types:--
(1)primary key constraint.
(2)unique constraint.
(3)foreign key constraint.
(4)check constraint.
(5)default constraint.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is difference between aggregate and analytic function?
What different steps will a sql server developer take to secure sql server?
What is Dependency Injection and provide example?
How to delete a database in ms sql server?
What are different types of subquery?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Explain unique key in sql server?
Determine when an index is appropriate?
List some major differences between triggers and stored procedures?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is open database communication (odbc)?
What is t-sql script to take database offline – take database online.
what is dbcc? : Sql server database administration
What is snapshot parameter in ssrs?
How can I change procedure name in sql server?