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
How you trouble shoot when any job fails
How to find the version of sql server? : sql server database administration
What is an index. What are the types?
Does transparent data encryption provide encryption when transmitting data across the network?
What encryption security is available in sql azure?
Why use identity in sql server?
what is difference between NULL and ISNULL in SQL Server 2008?
What is 'write-ahead log' in sql server 2000 ?
What is the difference between for trigger and after trigger?
How to test values returned by a subquery with the in operator?
How to create a testing table with test data in ms sql server?
do views contain data ?
What is resource governor?
Explain Geography datatype in SQL Server
Define a cross join?