gipasoft

Display All Column Collation

Apr 12th, 2018
274
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.31 KB | None | 0 0
  1. USE <databaseName>
  2. GO
  3. SELECT s.name AS 'Schema_Name', t.name AS TABLE_NAME,
  4. c.name AS Column_Name,
  5. c.collation_name AS Collation
  6. FROM sys.schemas s
  7. INNER JOIN sys.TABLES t
  8. ON t.schema_id = s.schema_id
  9. INNER JOIN sys.COLUMNS c
  10. ON c.object_id = t.object_id
  11. WHERE collation_name IS NOT NULL
  12. ORDER BY Column_Name
Advertisement
Add Comment
Please, Sign In to add comment