达梦数据库SQL脚本之批量删除模式下所有表
DECLAREVAR1VARCHAR(20) := 'TEST';TAB_NAME VARCHAR(100);SQL1VARCHAR(500);SQL2VARCHAR(500);C1 CURSOR;BEGINSQL1 = 'SELECT TABLE_NAME FROM DBA_TABLES WHERE OWNE...
·
DECLARE
VAR1 VARCHAR(20) := 'TEST';
TAB_NAME VARCHAR(100);
SQL1 VARCHAR(500);
SQL2 VARCHAR(500);
C1 CURSOR;
BEGIN
SQL1 = 'SELECT TABLE_NAME FROM DBA_TABLES WHERE OWNER = '''||VAR1||''';';
OPEN C1 FOR SQL1;
LOOP
FETCH C1 INTO TAB_NAME;
EXIT
WHEN C1%NOTFOUND;
SQL2 = 'DROP TABLE "' || VAR1 || '"."' ||TAB_NAME || '";' ;
EXECUTE IMMEDIATE SQL2;
END LOOP;
CLOSE C1;
END
欢迎关注我的博客《Jackin's Blog - 知识改变命运》学习分享更多知识
更多推荐
已为社区贡献5条内容
所有评论(0)