About Blog Tutorials

SQL Rename Table

The following command will rename rent_payments to accounts_receivable.

PostgreSQL, MySQL, Oracle

SQL Server

ALTER TABLE rent_payments RENAME TO accounts_receivable;

sp_rename 'rent_payments', 'accounts_receivable';