清除数据

Declare @t table(query varchar(2000),tables varchar(100))     
Insert into @t   
    select 'Truncate table ['+T.table_name+']', T.Table_Name from INFORMATION_SCHEMA.TABLES T     
    left outer join INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC     
    on T.table_name=TC.table_name     
    where (TC.constraint_Type ='Foreign Key' or TC.constraint_Type is NULL) and   
    T.table_name not in ('dtproperties','sysconstraints','syssegments') and   
    Table_type='BASE TABLE'   
Insert into @t   
    select 'delete from ['+T.table_name+']', T.Table_Name from INFORMATION_SCHEMA.TABLES T     
        left outer join INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC     
      on T.table_name=TC.table_name where TC.constraint_Type ='Primary Key' and T.table_name <>'dtproperties'and Table_type='BASE TABLE'   
Declare @sql varchar(8000)     
Select @sql=IsNull(@sql+' ','')+ query from @t   
print(@sql)     
Exec(@sql)

 

 

 

http://topic.csdn.net/u/20091215/09/33c8705f-b5d5-48e5-a18e-6894290e1620.html