How to get the collation of an Index-Column?

[HrungDak]

Hi,

i have to write an app that shows all indexes of a databasetable with their columns.

The problem is: i cannot find the table where the collation of a single indexfield is stored. i looked in sysindexes, sysindexkeys and sysconstraints.

where is the collation of an indexkey located?

Thanks

Alex Frankenberger
---------------------------------------
- Don't panic -

 

[TheBugSlayer]

"Contains one row for every column in every table and view, and a row for each parameter in a stored procedure. This table is in each database.". That is from the SQL BOL. Lookup SYSCOLUMNS table and read up on it.

 

[TheBugSlayer]

"Contains one row for every column in every table and view, and a row for each parameter in a stored procedure. This table is in each database.". That is from the SQL BOL. Lookup SYSCOLUMNS table and read up on it.h, and it tells you the collation of each column.