MSSQL database clearing method

1. Clear all tables in the database 
Copy codeThe Code is as follows:
DECLARE @ tablename varchar (50)
DECLARE @ truncatesql varchar (255)
DECLARE TrCun_Cursor CURSOR
Select [name] from sysobjects where type = 'U'
-- Conditional table name clearing <> 'table name not wanting to be cleared '--
OPEN TrCun_Cursor
FETCH TrCun_Cursor
@ Tablename
WHILE (@ fetch_status = 0)
BEGIN
SET @ truncatesql = 'truncate table' + @ tablename
-- Exec (@ truncatesql) -- remove it when you want to delete it --
PRINT @ truncatesql
FETCH TrCun_Cursor INTO @ tablename
END
CLOSE TrCun_Cursor
DEALLOCATE TrCun_Cursor

2. Clear all data in the database
EXEC sp_MSforeachtable "truncate table? "