SQL Server 2022

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

CREATE TABLE dbo.Test ("[I]" int,
                       "[D]" date);
EXEC sys.sp_rename N'dbo.Test."[I]"','I', N'COLUMN';
EXEC sys.sp_rename N'dbo.Test.[[D]]]','D', N'COLUMN';
Caution: Changing any part of an object name could break scripts and stored procedures.
Caution: Changing any part of an object name could break scripts and stored procedures.


SELECT *
FROM dbo.Test


I
D


DROP TABLE dbo.Test;