Truncate all tables by Schema
As I mainly work in development of SQL Server databases or data marts for data warehouses, I quite often use schemas (which are massively under utilised) in the database to separate out tables into sections of relative data. After typing out TRUNCATE TABLE statements for numerous tables in a certain schema I decided it was […]