IFEXISTS (SELECT name FROM sysobjects WHERE name='DROPTABLE') DROPPROCEDURE DROPTABLE GO CREATEPROCEDURE DROPTABLE @keychar(20) AS DECLARE @nameVARCHAR(20) BEGIN DECLARE DBNAMES CURSORFOR SELECT name FROM sysobjects WHERE type='U'AND name like'INVM%' OPEN DBNAMES --取值 FETCHNEXTFROM DBNAMES INTO@name WHILE (@@FETCH_STATUS=0) BEGIN EXEC ('DROP TABLE '+@name) --取下一笔 FETCHNEXTFROM DBNAMES INTO@name END --关闭游标 CLOSE DBNAMES DEALLOCATE DBNAMES END GO EXEC DROPTABLE 'AST'