如何更改db2的schema
1个回答
2015-06-18 · 知道合伙人数码行家
huanglenzhi
知道合伙人数码行家
向TA提问 私信TA
知道合伙人数码行家
采纳数:117538
获赞数:517163
长期从事计算机组装,维护,网络组建及管理。对计算机硬件、操作系统安装、典型网络设备具有详细认知。
向TA提问 私信TA
关注
展开全部
set the current schema for db2admin to kjc:
SET CURRENT SCHEMA = 'KJC'
if you want to change schema for those tables you need to export the DDL and manually change the schema name, then export the data, drop db, create new db, import DDL and load the data back
SET CURRENT SCHEMA = 'KJC'
if you want to change schema for those tables you need to export the DDL and manually change the schema name, then export the data, drop db, create new db, import DDL and load the data back
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询