Re: i have table

On 10/5/06, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:
>
> On Wed, Oct 04, 2006 at 11:20:07AM -0500, Aaron Bono wrote:
> >
> > So do it as needed and convert your application slowly.
>
> You don't even need to do that.
>
> ALTER TABLE tablename RENAME TO tablename_real;
>
> CREATE VIEW tablename [&c.]
>
> Now the view looks to the application just like the old table. If
> you want to insert &c., you put some rules there.

If you do this you need to make the view updateable or
inserts/updates/deletes will break.

==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================