Drop multiple columns from table
How to drop multiple columns from existing table. Alter syntax and example.
Syntax
ALTER TABLE table_name DROP COLUMN column_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),
first_name varchar(100)
last_name varchar(100)
);
Example Drop multiple columns
ALTER TABLE users DROP COLUMN first_name, DROP COLUMN last_name RESTRICT;