Oracle 修改表名

2024-08-29 16:54:52

1、ALTER TABLE T_PLAT_KEYWORD_STATISTIC RENAME TO T_PLAT_KEYWORD;

2、create 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

最新文章

热门文章