declare @sqlstr varchar(500) DECLARE @TableName VARCHAR(100) DECLARE curTables CURSOR STATIC LOCAL FOR SELECT Table_Name FROM Information_Schema.Tables WHERE Table_Type = 'BASE TABLE' and table_name like '_wcikk_arak%' OPEN curTables FETCH NEXT FROM curTables INTO @TableName SET @TableName = RTRIM(@TableName) WHILE @@FETCH_STATUS = 0 BEGIN set @sqlstr='DROP TABLE ' + @TableName exec(@sqlstr) FETCH NEXT FROM curTables INTO @TableName END CLOSE curTables DEALLOCATE curTables exec tolt_vcikk_arak exec tolt_wcikk_arak_web insert into verzio values('upg','Ver. 2.78', dbo.mygetdatetime()) go