Subject | Re: [firebird-support] Renaming tables in Firebird |
---|---|
Author | Milan Babuskov |
Post date | 2006-12-29T14:52:11Z |
Bert_Herngreen wrote:
you can easily create a view which would work as an alias, something like:
CREATE VIEW Y
AS
SELECT * FROM X;
--
Milan Babuskov
http://njam.sourceforge.net
http://www.flamerobin.org
> What is the reason that renaming tables in Firebird is not possible byA tip: if you really need to call it differently for whatever reason,
> a (single) statement like 'ALTER TABLE X RENAME TO Y'. Does it have a
> technical reason and would it be hard to implement in the engine?
you can easily create a view which would work as an alias, something like:
CREATE VIEW Y
AS
SELECT * FROM X;
--
Milan Babuskov
http://njam.sourceforge.net
http://www.flamerobin.org