Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

JetGetTableIndexInfo Function

Windows

Last modified: January 09, 2012

Applies to: Windows | Windows Server

The JetGetTableIndexInfo function retrieves information about an index.

JET_ERR JET_API JetGetTableIndexInfo(
  __in          JET_SESID sesid,
  __in          JET_TABLEID tableid,
  __in          const tchar* szIndexName,
  __out         void* pvResult,
  __in          unsigned long cbResult,
  __in          unsigned long InfoLevel
);

Parameters

sesid

The database session context to use for the API call.

tableid

The database table that contains the index that holds the needed information.

szIndexName

The name of the index that contains information that will be retrieved.

pvResult

Pointer to a buffer which will receive the information. The buffer should be aligned to hold the type required. The type of the buffer is dependent on the InfoLevel parameter.

cbResult

The size, in bytes, of the buffer passed in the pvResult parameter.

InfoLevel

Specifies which information will be stored in pvResult. The valid values are:

Value

Meaning

JET_IdxInfo

pvResult is interpreted as a JET_INDEXLIST structure. On success, the JET_INDEXLIST structure receives information about the index. On failure, the contents of pvBuffer are undefined.

JET_IdxInfoLCID

pvResult is interpreted as an LCID. On success, the LCID holds the Locale Identifier of the index. On failure, the contents of pvBuffer are undefined.

JET_IdxInfoList

pvResult is interpreted as a JET_INDEXLIST structure. On success, the JET_INDEXLIST structure receives information about the index. On failure, the contents of pvBuffer are undefined.

JET_IdxInfoOLC

JET_IdxInfoOLC is obsolete.

JET_IdxInfoResetOLC

JET_IdxInfoResetOLC is obsolete.

JET_IdxInfoSpaceAlloc

pvResult is interpreted as a ULONG. On success, the ULONG holds the space usage of the index. On failure, the contents of pvBuffer are undefined.

JET_IdxInfoSysTabCursor

JET_IdxInfoSysTabCursor is obsolete.

JET_IdxInfoLangid

JET_IdxInfoLangid is deprecated. Use JET_IdxInfoLCID instead, and the LANGIDFROMLCID macro instead.

JET_IdxInfoCount

pvResult is interpreted as a ULONG. On success, the ULONG holds the count of indexes on the specified table. szIndexName is ignored. On failure, the contents of pvBuffer are undefined.

JET_IdxInfoVarSegMac

pvResult is interpreted as a USHORT. On success, the USHORT holds the value of cbVarSegMac used when the index was created. See JET_INDEXCREATE for a description of cbVarSegMac. On failure, the contents of pvBuffer are undefined.

JET_IdxInfoIndexId

pvResult is interpreted as a JET_INDEXID. On success, the JET_INDEXID structure receives information about the index. On failure, the contents of pvBuffer are undefined.

JET_IdxInfoKeyMost

pvResult is interpreted as a USHORT. On success, the USHORT holds the value of cbKeyMost used when the index was created. See the JET_INDEXCREATE structure for a description of cbKeyMost. On failure, the contents of pvBuffer are undefined.

JET_IdxInfoCreateIndex

pvResult is interpreted as a JET_INDEXCREATE structure. On failure, the contents of pvBuffer are undefined.

Windows 7:  JET_IdxInfoCreateIndex is introduced in Windows 7.

JET_IdxInfoCreateIndex2

pvResult is interpreted as a JET_INDEXCREATE2 structure. On failure, the contents of pvBuffer are undefined.

Windows 7:  JET_IdxInfoCreateIndex2 is introduced in Windows 7.

Return Value

This function returns the JET_ERR datatype with one of the following return codes. For more information about the possible ESE errors, see Extensible Storage Engine Errors and Error Handling Parameters.

Return code

Description

JET_errSuccess

The operation completed successfully.

JET_errIndexNotFound

The specified index cannot be found in the specified table.

JET_wrnBufferTruncated

The buffer passed in as pvResult was too small. The contents of the buffer are undefined.

Remarks

JetGetIndexInfo and JetGetTableIndexInfo retrieve identical information about an index. The difference is in how the table is specified. JetGetIndexInfo expects a database (dbid) and name of a table (szTableName), while JetGetTableIndexInfo expects a table identifier (tableid).

Requirements

Client

Requires Windows Vista, Windows XP, or Windows 2000 Professional.

Server

Requires Windows Server 2008, Windows Server 2003, or Windows 2000 Server.

Header

Declared in Esent.h.

Library

Use ESENT.lib.

DLL

Requires ESENT.dll.

Unicode

Implemented as JetGetTableIndexInfoW (Unicode) and JetGetTableIndexInfoA (ANSI).

See Also

Show:
© 2014 Microsoft