首页 > 代码库 > Oracle 修改表名

Oracle 修改表名

1ALTER TABLE T_PLAT_KEYWORD_STATISTIC RENAME TO T_PLAT_KEYWORD;2create new_table as select * from old_table;drop table old_table;3、SQL> select tname from tab;TNAME------------------------------TEST SQL> rename test to temp ;Table renamed. SQL> select tname from tab ;TNAME------------------------------TEMP

 

Oracle 修改表名