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

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
The following script will help you to get all the columns with different collation than the one specified as default for a database.