DECLARE @tablename varchar(1000)
DECLARE cursor_name CURSOR
FOR select name from sysobjects where name like 'tableName%'
OPEN cursor_name
FETCH NEXT FROM cursor_name
INTO @tablename
WHILE @@FETCH_STATUS = 0
BEGIN
exec ( 'drop table '+@tablename)
FETCH NEXT FROM cursor_name
INTO @tablename
end
sql server 2005批量删除表
最新推荐文章于 2022-08-30 15:16:53 发布