INDEX Create INDEX   is used to create indexes in tables. Indexes are used to rapidly create and re…

CHECK  The CHECK constraint is used to give the limit for the values given on the column. CHECK is …

Default Default Constraints is used to specify the constant value for a column. and the user does n…

UNIQUE In SQL,  UNIQUE constraint uniquely identifies each record in a database table. There can b…

Foreign Key A Foreign Key is one table point to a PRIMARY KEY in another table.  Foreign Key is u…

Primary Key The PRIMARY KEY Constraint used to uniquely identifies each record in a  table.  Prima…

NOT NULL If no value is given in each column of the table of SQL, then by default is 'NULL'…