gipasoft

Show Collation for all Fields of Table

Mar 31st, 2017
263
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.14 KB | None | 0 0
  1. USE FAD05roadmapanestesia14
  2.  
  3. SELECT
  4.     col.name, col.collation_name
  5. FROM
  6.     sys.columns col
  7. WHERE
  8.     object_id = OBJECT_ID('Provincia')
Advertisement
Add Comment
Please, Sign In to add comment