Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rafal S. Show all database's tables' columns' collations. RE: Show all database's tables' columns' collations.
pcd_au
Ten Centuries
Points: 1289
More actions
April 4, 2008 at 3:20 am
#798273
to get the collation of a column of a table
select COLLATION_NAME
from information_schema.columns
-- you complete this bit as necessary
where table_name like '%'
and column_name like '%'
or have I missed something?
pcd