飞飞的博客

当数据库表结构发生改变需要重新注册表结构：call sysproc.admin_cmd('reorg table [Schema].[表名]');例如：call sysproc.admin_cmd('reorg table DB2ADMIN.student_Info');

详细参照：https://www.2cto.com/database/201303/196830.htmlcreate sequence seq_xxx; 创建 seq_xxx序列alter sequence seq_xxx restart with 10; 修改seq_xxx序列值从10开始 （省略with 10就是从0开始计数）select  nextval for seq_xxx...