• If not references are present on the tables:

    EXEC sp_MSForEachTable 'truncate TABLE ? ' will be enough to truncate all tables.

    the sp_MSForEachTable replace the ? for the actual table Name.