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

Does sql require a server?

703


How does postgresql compare to oracle/db2/ms sql server/informix?

772


What are the constraints available in sql?

780


What is full form of rtm?

721


What is dml and ddl?

713






Can a primary key be a foreign key?

750


what tools available for managing mysql server? : Sql dba

745


What do you mean by field in sql?

784


Is sql microsoft?

709


What plvcmt and plvrb does in pl/sql?

1058


What are functions in sql?

654


What is replication id?

683


Is mariadb a nosql database?

760


How do I install sql?

697


What is the difference between a subquery and a join?

698