摘要:
DECLARE @table varchar(64),@sql varchar(150)DECLARE curTable SCROLL CURSOR FOR SELECT name FROM sysobjects WHERE Type = 'U' And Name <> 'dtproperties' ORDER BY nameOPEN curTableFETCH FIRST FROM curTable INTO @tableWHILE (@@FETCH_STATUS = 0)BEGINset @sql = 'Drop table [' 阅读全文