What is a constraint. Types of constraints ?

Answer Posted / samuvel

Constraint is a restriction on table

Types:

1)Column Constraints:applicable for column level
i)unique ii) not null

2)Table constraints:applicable for table level
1)primary key ii) foreign key d. check

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the join types in tsql? : Transact sql

568


What are the three pl sql block types?

567


What is mutating trigger?

572


What is trigger with example?

560


Explain the significance of the & and && operators in pl sql.

566






What is the difference between execution of triggers and stored procedures?

548


What is sql lookup?

508


how can you see all indexes defined for a table? : Sql dba

537


Enlist the data types that can be used in pl/sql?

568


What is a pl/sql block?

586


Which one is better subquery or joins?

550


What is the difference between delete and truncate commands?

509


Can we insert data in view?

498


Can we join two tables without common column?

507


What is difference between primary and secondary key?

515