Add default value of datetime field in SQL Server to a timestamp ...

For modifying an existing column in an existing table: ALTER TABLE YourTable ADD CONSTRAINT DF_YourTable DEFAULT GETDATE() FOR ...

stackoverflow.com