SQL RENAME COLUMN
The following command will rename last_name to surname in the tenants table.
PostgreSQL, MySQL, Oracle
SQL Server
ALTER TABLE tenants RENAME COLUMN last_name TO surname;