Change Datatype of Column

The following query will change the zip_code column, in the rent_payments table, to type INT.

PostgreSQL, Oracle

MySQL

SQL Server

ALTER TABLE rent_payments ALTER COLUMN zip_code TYPE INT;