×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Finding Collations
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday Jun 28th 2018 by Hannes du Preez

Language: SQL, Expertise: Beginner - Learn how to find collations in your tables.

To find Collations in your table, you can use the following:

SELECT
    SysCol.Name, SysCol.Collation_Name
FROM 
    sys.Columns SysCol
WHERE
    Object_ID = OBJECT_ID('YOUR_TABLE_NAME')

Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved