m.tonies@... wrote:

>
> Hi there,
>
> I was just wondering, is there a way to change the name of a existing,
> populated table. Can you UPDATE the RDB$RELATIONS table to do this?
>

I very much doubt it.

I looked at the issues involved in doing this a little while ago. There look
like there are way too many dependancies - columns, column constraints,
triggers, indexes etc. All of these need to be pointed to the new table name. I
decided it wasn't worth the effort to work out which order to do it in,
especially as there are likely to be system constraints to make the whole
venture worthless.

Nice idea, though.

Paul
--

Paul Reeves
Fleet River Software
/***************************************************************************
* v1.0 of the InterBase Heartbeat - Database Monitor is now available. *
* Visit http://www.fleetriver.demon.co.uk to download an evaluation copy. *
***************************************************************************/