What are the Defaults in Sql?

Answer 1

When you create a table, you can specify a DEFAULT value for each column which will be applied in the absence of an explicit value. For example;

create table MYTABLE (

ID int,

NAME varchar(40),

TYPE int NULL DEFAULT 0)

go

insert into MYTABLE (ID, NAME) values (1,'record one')

Although a value hasn't been provided for the column TYPE, the insert will create a record with a value of '0'.