Then, it will be light & table name changing (or temporary tables managing) will be simplification and reduction the operation time.
On 3/4/08, edward yoon <[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. > > > 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. > -- B. Regards, Edward yoon @ NHN, corp.
