SQL Server 2019

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

CREATE TABLE t(i INT, col1 INT, col2 INT);
SELECT * FROM t;


i
col1
col2


ALTER TABLE t DROP COLUMN IF EXISTS col1, col2;
SELECT * FROM t;


i


ALTER TABLE t DROP COLUMN IF EXISTS col1,  col2;
SELECT * FROM t;
Msg 4924 Level 16 State 1 Line 1
ALTER TABLE DROP COLUMN failed because column 'col2' does not exist in table 't'.