Altering a Column Which has a Default Constraint
- by Dinesh Asanka
Setting up a default column is a common task for developers.
But, are we naming those default constraints explicitly?
In the below table creation, for the column, sys_DateTime the
default value Getdate() will be allocated.
CREATE TABLE SampleTable
(ID int identity(1,1),
Sys_DateTime Datetime DEFAULT getdate()
)
We can check the…