How to rename table in firebird 2.5 ?
I'm using query : ALTER TABLE cliente RENAME TO clientes; , but the error appears:
invalid toke 'rename'.
Rename table in firebird
4
asked by anonymous 16.01.2017 / 15:22
2 answers
1
Victor,
According to the Firebird FAQ it is not possible to rename a table in firebird, as reported in this link . You can create a new table or a view by selecting data from the old table.
16.01.2017 / 17:50
0
Victor,
By taking a look at your question, and after a search, actually by the traditional command of ALTER TABLE it is not possible to rename a table, however I found something that might help you, look at this SQL command here , I hope it helps.
16.01.2017 / 18:00