How to list all table's collation?

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Mark Cowne One Orange Chip Points: 26980 More actions · Answer 1

select object_name(object_id) as tablename, name as columnname,collation_name

from sys.columns

where collation_name is not null

order by object_name(object_id),column_id

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

Cookies on SQLServerCentral