Is it possible to rename a table in Firebird? Is it possible to rename a table in Firebird? sql sql

Is it possible to rename a table in Firebird?


Apparently not.

You must either create a new table, copying over old values or create a view with the intended name which is identical to the original table.

See http://www.firebirdfaq.org/faq363/ for further details.


It is possible to change the column name by:

ALTER TABLE "tableName" ALTER "columnName" TO "NewColumnName";