DB2 Exists 判断表是否存在以及动态执行SQL语句

最新推荐文章于 2024-08-01 11:05:55 发布

Leon1509

最新推荐文章于 2024-08-01 11:05:55 发布

阅读量3.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： DB2 文章标签： db2

本文链接：https://blog.csdn.net/Leon1509/article/details/84356023

DB2 专栏收录该内容

6 篇文章

订阅专栏


IF NOT EXISTS (SELECT * FROM SYSIBM.SYSTABLES WHERE TID <> 0 AND Name = 'TABLE_NAME' AND Creator  = 'DB2INST1') THEN
		SET v_Sql = 'CREATE TABLE ' || v_Schema || '.' || v_TabName || ' LIKE ' || v_Schema || '.FTP_Jlkh_Map_Template IN ccp_data';
		PREPARE s1 FROM v_Sql;
		EXECUTE s1;

		SET v_Sql = 'ALTER TABLE ' || v_Schema || '.' || v_TabName || ' ADD PRIMARY KEY(Curr_Date,autoid)';
		PREPARE s1 FROM v_Sql;
		EXECUTE s1;
END IF;