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 is the maximum number of triggers, you can apply on a single table?
What are the benefits of stored procedures?
How can I speed up sql query?
explain the difference between delete , truncate and drop commands? : Sql dba
what is the difference between delete and truncate statement in sql? : Sql dba
Why does sql need a server?
How do I know if I have sql express or standard?
What is the difference between between and in condition operators?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
How many types of literals are available in pl sql?
what are the different type of sql's statements ? : Sql dba
What does count (*) mean in sql?
Are subqueries faster than joins?
Is it important to partition hard disk?
what are the advantages and disadvantages of cascading style sheets? : Sql dba