Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to list all table's collation?

Author  Topic 

ikura
Starting Member

5 Posts

Posted - 2009-01-13 : 21:49:29
Hello!!

I would like to know how to list all table's collation in a DB by T-SQL. Please help!!!!


wongkwokkin@gmail.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-13 : 23:10:17
you can get this info from collation_name column of sys.columns view
Go to Top of Page
   

- Advertisement -