PostgreSQL: How to remove a column from a table ?

Use this sintaxe:

ALTER TABLE {TABLE_NAME} DROP COLUMN {COLUMN_NAME};

Example:

ALTER TABLE material DROP COLUMN classificacao;

Leave a comment