CODEWITHSUNDEEP
postgresql
Shahal
Shahal

Reputation: 75

PostgreSQL DROP COLUMN: Remove One or More Columns of a Table

To drop a column of a table, you use the DROP COLUMN clause in the ALTER TABLE statement as follows:

ALTER TABLE res_partner rs 
DROP COLUMN rs.miss_schedule;

ERROR: syntax error at or near "rs" LINE 1: ALTER TABLE res_partner rs

Upvotes: 3

Views: 2572

Answers (1)

Philippe
Philippe

Reputation: 1827

Try this query with no alias

ALTER TABLE res_partner DROP COLUMN miss_schedule;

Upvotes: 5

Related Questions