> >Also, just look
> >at the support for external procedures that is in development at the
> >moment, a person might not know if one of them depends on the table
> >that is being renamed.
> >
> >
> Yes, but on the other hand, this is sort of the same problem as with
> external client applications. Obviously, if you have developped an
> external procedure that is dependant on a certain table name, you will
> need to alter it before you can expect it to work. But I don't see that
> as being a big problem...

Or simply create a view:

CREATE VIEW <oldtablename> AS
SELECT <required_colums> FROM newtable

:-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com