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
Tag: table
How To #4 – Get the columns with non-default collation
The following script will help you to get all the columns with different collation than the one specified as default for a database.