db2如何重命名表?
程序员文章站
2022-03-08 23:17:52
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.
上一篇: Premiere怎么制作星星发光效果?
下一篇: vivos7t对比vivoS9e哪个好?