Use of Default in SQL
DEFAULT is used to provide a default value to a column in SQL that case when there is no value specified by the user, in SQL DEFAULT is a constraint.
Default Example With Query
Here we are going to make the SQL DEFAULT constraint more understanding with the query example. Let's suppose, we are creating a SQL TABLE with the name of Employee with DEFAULT.
CREATE TABLE Employee (
E_ID int NOT NULL,
E_NAME varchar (100) NOT NULL,
E_EMAIL varchar (100),
E_ADDRESS char (200),
E_SALARY decimal (100, 3) DEFAULT 10000,
E_AGE Int NOT NULL,
PRIMARY KEY(E_ID)
);