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.
上一篇: MongoDB数据库使用教程
下一篇: MongoDB常见的登录错误及解决办法