I have a table called sample and it has a column called [__INSERT_DATE] which is null. Now I want to alter the column with default as getdate()
. When I tried the following it gave me an error.
ALTER TABLE sample
ALTER COLUMN [__INSERT_DATE] [datetime] DEFAULT (getdate()) NULL)
Can anyone tell me what the problem is?
See Question&Answers more detail:os