How To #5 – Truncate all/multiple tables in a database

You can use this script to truncate tables:

  • When you want to clean all tables in a database/schema but keep the design and not recreate the objects
  • During the initial testing period or early stages of a database design

Be very careful if using any form of this script against a production database.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

nine + nineteen =