Is it possible to rename a table in Firebird?

Question

Is it possible to rename a table in Firebird or I should create a new table and then move the data using insert?

See http://www.firebirdfaq.org/faq363/ – Martijn Pieters Sep 18 '15 at 18:41 — Martijn Pieters, Sep 18 '15 at 18:41
See also: http://tracker.firebirdsql.org/browse/CORE-2486 – Lukas Eder Jan 21 '21 at 13:43 — Lukas Eder, Jan 21 '21 at 13:43

score 9 · Answer 1 · answered Oct 22 '15 at 11:01

9

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.

answered Oct 22 '15 at 11:01

score -6 · Answer 2 · edited Aug 24 '17 at 18:01

-6

It is possible to change the column name by:

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

edited Aug 24 '17 at 18:01

Daniel

answered Mar 03 '14 at 09:31

For me it works in Firebird Firebird 3.0! – Hans-Ulrich Hölscher Jan 20 '23 at 11:15

2 Answers2