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

Tag: table

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
icon_howto

How To #4 – Get the columns with non-default collation

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

The following script will help you to get all the columns with different collation than the one specified as default for a database.

Posted in How to Tagged collation, column, database, default, get, query, server, table, tsql Leave a comment

Easy search

Join Our Meetup

Pluralsight

Theme by Out the Box