db2如何重命名表?,db2重命名表?
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.
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。