Default Value for DATETIME column in SQL Server Management Studio 2017

Question

Is it possible to create a table with a column that has type DATETIME and give it a default value such as CURRENT_TIMESTAMP or GETDATE()? Is there another way to do this?

Screenshot from SSMS 2017

Answer 1

Define a constraint using TSQL:

ALTER TABLE TableName ADD CONSTRAINT DF_TableName DEFAULT GETDATE() FOR ColumnName