CODEWITHSUNDEEP
sqlfirebird
zac
zac

Reputation: 4908

Is it possible to rename a table in Firebird?

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

Upvotes: 13

Views: 15180

Answers (2)

Gianluca Pasqualato
Gianluca Pasqualato

Reputation: 153

It is possible to change the column name by:

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

Upvotes: -5

Morten Christiansen
Morten Christiansen

Reputation: 19570

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.

Upvotes: 9

Related Questions