Directly renaming table in db2 is difficult. Alternet approch to achieve the same is:
Create table <NewTableName> like <ExistingTableName>
--- It will create same table structure as of existing table
insert into <NewTableName> select * from <ExistingTableName>
--- It will insert all data what we had in existing one.
Create table <NewTableName> like <ExistingTableName>
--- It will create same table structure as of existing table
insert into <NewTableName> select * from <ExistingTableName>
--- It will insert all data what we had in existing one.
No comments:
Post a Comment