> We'd need to add a new table operation for renaming a table > internally. The ugly part is that we'd have to rewrite every row for > the table in META to do this.
In fact, i thought a physical/logical table name management for high-performance without no changing the meta data. On 3/4/08, Bryan Duxbury <[EMAIL PROTECTED]> wrote: > We'd need to add a new table operation for renaming a table > internally. The ugly part is that we'd have to rewrite every row for > the table in META to do this. > > The SQL way to do this would be "ALTER TABLE table RENAME new name". > However, that's a bit verbose, so I think "RENAME table TO new_table" > would be fine. > > > -Bryan > > > On Mar 2, 2008, at 9:56 PM, edward yoon wrote: > > > A renaming function of table alteration is needed. > > Is there a tool for renaming the table? > > > > Any ideas please post back. > > Also, i'd like to add renaming syntax to hql as describe below. > > > > hql > RENAMING table_name TO new_table_name; > > > > What do you think? > > -- > > B. Regards, > > Edward yoon @ NHN, corp. > > -- B. Regards, Edward yoon @ NHN, corp.
