Rename table in Firebird

Asked

Viewed 2,287 times

4

How to rename table in firebird 2.5?

I’m using the query: ALTER TABLE cliente RENAME TO clientes;, but error appears:

invalid Toke 'Rename'.

sql database firebird

2 answers

1


Victor,

as the Firebird FAQ is not possible to rename table in Firebird, as reported in this link. You can create a new table or view by selecting data from the old table.

0

Victor,

Taking a look at your question, and after a search, really by the traditional command of ALTER TABLE cannot rename a table, but I found something that can help you, take a look at this SQL command here, hope it helps.

Browser other questions tagged sql database firebird

You are not signed in. Login or sign up in order to post.