Synonym table relationship

From: Mark Burns <mburns_at_sjm.com>
Date: 21 May 2002 16:17:42 -0700
Message-ID: <549bf180.0205211517.53f7bac1@posting.google.com>

I have a synonym(in user2 schema)referring to a table in user1 schema. If I drop the table in user1 and then recreate it with different structure(i.e. change columns), will I have to also recreate the synonym?
I thought that the synonym was dynamic and so if the table underneath was changed then it should not make a difference. Is this true? Is the structure of the synonym saved?, I thought it was more like a pointer to the table.

thanks
Mark Received on Tue May 21 2002 - 18:17:42 CDT