Martijn Tonies wrote (on Tuesday, August 23, 2005 10:36 AM):

>
> In some cases, the following solution might help:
>
> create view mynewname as select * from myoldtable
>
> :-)
>
> This is what we did when someone finally discovered a typo in a legacy
> table name already in use all over the bloody application! The guy who
> created the table and continued using it with the typo included was,
> obviously, smacked in the head :-)
>

Yeah, the idea with thw view is OK. ;)

--
Bc. Jiri Cincura
http://www.ID3renamer.com/
http://www.x2develop.com/
ICQ: 314711544 | Yahoo!: x2develop
http://photo.cincura.net/