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


Please Help Members By Posting Answers For Below Questions

how to convert character strings to numeric values? : Sql dba

771


Write a unique difference between a function and a stored procedure.

713


explain the options of myisamchk to improve the performance of a table. : Sql dba

721


how to create a new view in mysql? : Sql dba

685


what is sp_pkeys? : Transact sql

889






What is java sql connection?

693


What is number function in sql?

709


How many parts of a pl sql block are optional?

712


What is record data type?

677


What are the types of keys?

671


What are stuff and replace function?

770


What is partition in sql query?

721


What is the difference between unique and primary key constraints?

774


Who developed sql?

758


what is the difference between a local and a global temporary table? : Sql dba

741