欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

db2如何重命名表?

程序员文章站 2022-06-17 19:19:58
db2如何重命名表? 设置当前的schema: db2 => set schema db2admin DB20000I The SQL command compl...

db2如何重命名表?

设置当前的schema:
db2 => set schema db2admin
DB20000I  The SQL command completed successfully.

此时,命令中包含schema会报错:
db2 => rename table db2admin.test_tab to db2admin.test_tab1
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL0108N  The name "test_tab1" has the wrong number of qualifiers.  
SQLSTATE=42601

去掉schema可以成功重命名:
db2 => rename table test_tab to test_tab1
DB20000I  The SQL command completed successfully.