Declaring a default constraint when creating a table
Do it inline with the column creation: [load_date] SMALLDATETIME NOT NULL CONSTRAINT [df_load_date] DEFAULT GETDATE() I have used square brackets rather than quotes as many readers won’t work with QUOTED_IDENTIFIERS on by default.