Postgres 13

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

create table table_name (id int, column_name int);
insert into table_name values (1,100), (2,200);
2 rows affected

select *
from table_name

id
column_name

1
100

2
200

ALTER TABLE table_name 
DROP COLUMN column_name;
select *
from table_name

id

1

2