Mssql 生成批量清空表的脚本

SELECT  concat('IF EXISTS (select * from syscolumns where id=OBJECT_ID('',cast(B.NAME as varchar(100)),''))  TRUNCATE TABLE ',cast(B.NAME as varchar(100)),';')  AS TABLE_NAME        FROM sys.extended_properties A INNER JOIN sys.tables B ON A.MAJOR_ID = B.OBJECT_ID        WHERE A.MINOR_ID = '0';