SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE dbo.test (ID int);
INSERT INTO dbo.Test VALUES (1),(2),(3),(4),(5);
5 rows affected

ALTER TABLE dbo.Test ADD D datetime DEFAULT GETDATE() WITH VALUES;
SELECT *
FROM dbo.Test


ID
D


1
2024-05-15 09:47:22.907

2
2024-05-15 09:47:22.907

3
2024-05-15 09:47:22.907

4
2024-05-15 09:47:22.907

5
2024-05-15 09:47:22.907


DROP TABLE dbo.Test;

ID	D
1	2024-05-15 09:47:22.907
2	2024-05-15 09:47:22.907
3	2024-05-15 09:47:22.907
4	2024-05-15 09:47:22.907
5	2024-05-15 09:47:22.907