How to add a check key constraint on a table or column

 How to add a check key constraint on a table or column

ADD CHECK

 টেবিল তৈরীর পরে CHECK CONSTRAINT ADD করা ।

 

SQL> alter table pr_detail

add constraint chk_prtn_id check (pr_id between 1 and 100)

Table altered.

 

Not null constraint

Unique key constraint

Primary key constraint

Foreign key constraint