SQL by the book
  • Home
  • SQL Quiz
  • Math Quiz
  • Learning Corner
    • Understanding Query Execution Plans
  • How to
  • Thought Bubble
  • Contact Us

Tag: design

icon_howto

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

Posted on November 19, 2015November 17, 2016 by Florin Angelescu

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

Posted in How to Tagged automation, clean, database, dba, delete, design, drop, schema, server, sql, table, truncate Leave a comment

Easy search

Join Our Meetup

Pluralsight

Theme by Out the Box