clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591620 fiddles created (45702 in the last week).

select version();
version
PostgreSQL 12.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit
 hidden batch(es)


CREATE TABLE xyz (a INT PRIMARY KEY, b TEXT);
 hidden batch(es)


INSERT INTO xyz VALUES (1, 'sfasf'), (2, 'afdsa');
2 rows affected
 hidden batch(es)


ALTER TABLE xyz DROP COLUMN a;
 hidden batch(es)


SELECT * FROM xyz;
b
sfasf
afdsa
 hidden batch(es)