assign default value to datetime column in sql server while table creation code example

Example: sql set default value datetime now

ALTER TABLE YourTable ADD CONSTRAINT DF_YourTable DEFAULT GETDATE() FOR YourColumn