Is it possible to rename a table in Firebird?

sql firebird
Wel picture Wel · Sep 6, 2012 · Viewed 9.5k times · Source

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

Answer

Morten Christiansen picture Morten Christiansen · Oct 22, 2015

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.

Related questions

Generate insert SQL statements from a CSV file

I need to import a csv file into Firebird and I've spent a couple of hours trying out some tools and none fit my needs. The main problem is that all the tools I've been trying like EMS Data Import …

Read More
Combining UNION ALL and ORDER BY in Firebird

This is my first attempt at answering my own question, since someone may well run into this and so it might be of help. Using Firebird, I want to combine the results of two queries using UNION ALL, then sort …

Read More
C# constructing parameter query SQL - LIKE %

I am trying to build SQL for a parameter query in C# for a query which will contain the LIKE %% command. Here is what I am trying to acheive (please note that the database is Firebird) var SQL = string.format("…

Read More