Batch delete database table data backup

Batch delete database table data backup

 

-- Batch delete database table data
Declare @ Tbname Varchar ( 250 )
Declare # TB Cursor For Select Name From Sysobjects Where Objectproperty (ID, ' Isusertable ' ) = 1
Open # TB
Fetch Next From # TB Into @ Tbname
While @ Fetch_status = 0
Begin
Exec ( ' Delete [ ' + @ Tbname + ' ] ' )
Fetch Next From # TB Into @ Tbname
End
Close # TB  

Deallocate# TB