You are here:Home » SQL Server » Insert default values all columns of table

Insert default values all columns of table

We can insert all the default values in tables without specifying values while insert in table, how? See here we have tables defined all columns by default,
CREATE TABLE defaultval(
    id int default 0, 
    name varchar(10) default 'test', 
    cdate datetime default getdate()
);

INSERT defaultval DEFAULT VALUES;
Did you ever get used to it?