Alter table drop column from existing table

PostreSQL tutorial – Drop column

Drop column from existing table

How to drop column from existing table. Alter syntax and example.

Syntax

ALTER TABLE table_name 
  DROP COLUMN column_name RESTRICT;

Create table

CREATE TABLE users(
userid numeric not null 
default nextval('seq_users'::regclass),
username varchar(100),
userpass varchar(250),
usermail varchar(50),
address varchar(1000)  
);    

Example Drop column

ALTER TABLE users 
  DROP COLUMN address RESTRICT;

Alter table |
Drop table