InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 15:20:34 GMT20http://www.sqlservercentral.com/Forums/Topic449074-1184-1.aspxto get the collation of a column of a tableselect COLLATION_NAMEfrom information_schema.columns-- you complete this bit as necessarywhere table_name like '%'and column_name like '%' or have I missed something?pcdFri, 04 Apr 2008 03:20:04 GMTpcd_auhttp://www.sqlservercentral.com/Forums/Topic449074-1184-1.aspxHmm ...Right.My oversight.Sorry for that.Fri, 04 Apr 2008 02:46:28 GMTskrahttp://www.sqlservercentral.com/Forums/Topic449074-1184-1.aspxI had to add COLLATE Database_Default, in order to get it to work.As in:/********************************************************************************************* * Author Rafal Skotak* Purpose Created view displays all text columns' collations in the current database,* with the name of table which contains the column andwith the information whether* the collation is different from the database's one* Date 2008-01-22*/if exists(select * from sys.objects where object_id = object_id('dbo.view_show_tables_collations') and type = 'V') drop view dbo.view_show_tables_collationsgocreate view dbo.view_show_tables_collationsas select top 9223372036854775807 /* bigint maximum value; to cheat SS2005 You can try also 99.999999999999999999999999 percent */ ss.name as schema_name, so.name as table_name, sc.name as column_name, st.system_type_id, st.name as type_name, db_collation.collation_name as database_collation_name, sc.collation_name, case when db_collation.collation_name = sc.collation_name [b]COLLATE database_default[/b] then 0 else 1 end as collation_flagfrom sys.objects as so inner join sys.columns as sc on so.object_id = sc.object_id inner join sys.types as st on sc.system_type_id = st.system_type_id inner join sys.schemas as ss on ss.schema_id = so.schema_id cross join (select collation_name from master.sys.databases where database_id = db_id()) as db_collationwhere so.type = 'U' and st.system_type_id in (35 /* text */, 99 /* ntext */, 167 /* varchar */, 175 /* char */, 231 /* nvarchar, sysname */, 239 /* nchar */)order by collation_flag desc, schema_name, table_name, column_namego-- example, how to use:select * from dbo.view_show_tables_collationsFri, 04 Apr 2008 02:31:39 GMThenrik staun poulsenhttp://www.sqlservercentral.com/Forums/Topic449074-1184-1.aspxi awant all the table in databaseFri, 28 Mar 2008 21:22:51 GMTlavkushsharmahttp://www.sqlservercentral.com/Forums/Topic449074-1184-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/62042/">Show all database's tables' columns' collations.</A>[/B]Tue, 29 Jan 2008 13:51:19 GMTskra