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
In case you have filters in your report, when filters will be applied in cached report instance?
How to define and use table alias names in ms sql server?
What is an indexed view?
What is wide table?
What is the process of indexing?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
can an automatic recovery be initiated by a user? : Sql server administration
What is a unique index?
How to execute the cursor queries with "open" statements?
What is ms sql server service broker?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Can an entity have two primary keys?
How do you make a trace?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration