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 is procedure explain with example?

542


Is sql easier than java?

527


What sql does db2 use?

544


what are enums used for in mysql? : Sql dba

611


What are triggers and its types?

555






What is the advantage of index in sql?

541


what is the difference between a web-garden and a web-farm? : Sql dba

557


What are the different types of joins in sql?

585


What are different categories of sql commands?

635


How would you convert date into julian date format?

594


What is bind reference and how can it be created?

582


What are synonyms in sql?

535


What are sql objects?

543


What does count (*) mean in sql?

1095


How do I partition a table in sql?

542