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
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What are the advantages of sql azure?
User wants only to display only pdf as export option in report manager. How to achieve this?
Explain indexes disadvantages?
What happens if the update subquery returns multiple rows in ms sql server?
What do you mean by authentication modes in sql server?
How do I port a number to sql server?
What are the different types of indexes?
What is the maximum length of an alert name?
Explain Capacity planning to create a database? and how to monitor it?
How to convert numeric expression data types using the cast() function?
What is meant by datasource?
What is the difference between Normalization and De-normalization?
how to do partition in sqlserver
what is blocking? : Sql server database administration