How to identify which columns included in which index

Database
Enthusiast

How to identify which columns included in which index

indexes view do not contain columnname.

How to identify which column included in secondary/multicolumn/value-ordered indexes (other than using TD administrator).

Tags (1)
2 REPLIES
Senior Apprentice

Re: How to identify which columns included in which index

dbc.indexes in not a view, it's a table.

Use dbc.indicesV instead.

Dieter

Enthusiast

Re: How to identify which columns included in which index

u can use DBC.Indices also