The different types of constraints in DBMS are as follows:-

  • NOT NULL:-it makes sure that column does not hold a NULL value.
  • UNIQUE:- It invokes a column to have a UNIQUE value
  • DEFAULT:-gives the default value to the column
  • CHECK:-specify the range of values for a column
  • Key Constraints
  • PRIMARY KEY:-it diagnose each and every record in a table
  • FOREIGN KEY:- it points to the primary key of any other table.

Suggest An Answer

No suggestions avaliable!