如何在SQL Server中截断给定数据库的所有表

USE [数据库名称]

SELECT name FROM sys.tables

DECLARE @tableName NVARCHAR(128)
DECLARE @sql NVARCHAR(MAX)

DECLARE tableCursor CURSOR FOR
SELECT name FROM sys.tables

OPEN tableCursor
FETCH NEXT FROM tableCursor INTO @tableName

WHILE @@FETCH_STATUS = 0
BEGIN
    SET @sql = N'TRUNCATE TABLE ' + QUOTENAME(@tableName)
    EXEC sp_executesql @sql

    FETCH NEXT FROM tableCursor INTO @tableName
END

CLOSE tableCursor
DEALLOCATE tableCursor