overwrite schema.table name

From: Jan Gregor <gregor.jan_at_NOSPAM.quick.cz>
Date: Mon, 07 Nov 2005 09:59:00 +0100
Message-ID: <dkn4uf$703$1@ns.felk.cvut.cz>

Hello

Is it possible to overwrite schema.table_name to schema2.table_name. Situation is following - i have queries with fully specified table names (including used schema) and i want to use scripts on test data, so to use tables from another schema - for logging i use another use, another schema.
Is it possible ?

Thank,
Jan

p.s. of course i know synonyms are right solution (tables without schema), but i'm not the author. Received on Mon Nov 07 2005 - 02:59:00 CST