MetaDataCollectionName.IndexColumns Field

This metadata collection represents index columns in a database.

Pascal

const IndexColumns: string = "IndexColumns";

C++

string IndexColumns = "IndexColumns";

This metadata collection represents index columns in a database.

The columns are:

Column Name	Data Type	Description
CatalogName	String	The catalog name.
SchemaName	String	The schema name.
TableName	String	The table name.
IndexName	String	The index name.
ColumnName	String	A column in the index.
Ordinal	Int32	The position of the column in the index starting with 1.
IsAscending	Boolean	A descending index column.