PostgreSQL – Delete Column of Table

PostgreSQL – Delete Column

To delete one or more columns of a PostgreSQL table, run the following ALTER TABLE command.

 ALTER TABLE tablename 
	DROP COLUMN column_name;

Example 1 – Delete a Column of PostgreSQL Table

Consider the following table. We shall delete the column named percentage.