Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE <databaseName>
- GO
- SELECT s.name AS 'Schema_Name', t.name AS TABLE_NAME,
- c.name AS Column_Name,
- c.collation_name AS Collation
- FROM sys.schemas s
- INNER JOIN sys.TABLES t
- ON t.schema_id = s.schema_id
- INNER JOIN sys.COLUMNS c
- ON c.object_id = t.object_id
- WHERE collation_name IS NOT NULL
- ORDER BY Column_Name
Advertisement
Add Comment
Please, Sign In to add comment