What is a constraint. Types of constraints ?
Answer Posted / sohail
Constraint is a restriction on table.There are two types of
constraints 1.ananymous constraint and 2.named
constraint.under named and ananymous constraints there are
1.primary key constraint
2.foreign key constraint
3. not null constraint
4. check constraint
5. unique constraint.
| Is This Answer Correct ? | 40 Yes | 10 No |
Post New Answer View All Answers
What are stored procedures used for?
Is it possible for a table to have more than one foreign key?
What makes a good primary key?
How do I save the results of sql query in a file?
how to start mysql server? : Sql dba
How do you remove duplicates without using distinct in sql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Can we update views in sql?
How is a process of pl/sql compiled?
which tcp/ip port does sql server run on? : Sql dba
Why schema is used in sql?
What is view? Can we update view
How do you delete a table?
what is an index? : Sql dba
What are the types of optimization?