Edit

Share via


JET_TblInfo enumeration

Info levels for retrieving table info with JetGetTableInfo.

Namespace:  Microsoft.Isam.Esent.Interop
Assembly:  Microsoft.Isam.Esent.Interop (in Microsoft.Isam.Esent.Interop.dll)

Syntax

'Declaration
Public Enumeration JET_TblInfo
'Usage
Dim instance As JET_TblInfo
public enum JET_TblInfo

Members

Member name Description
Default Default option. Retrieves a JET_OBJECTINFO containing information about the table. Use this option with JetGetTableInfo(JET_SESID, JET_TABLEID, JET_OBJECTINFO, JET_TblInfo).
Name Retrieves the name of the table. Use this option with JetGetTableInfo(JET_SESID, JET_TABLEID, String, JET_TblInfo).
Dbid Retrieves the JET_DBID of the database containing the table. Use this option with JetGetTableInfo(JET_SESID, JET_TABLEID, JET_DBID, JET_TblInfo).
SpaceUsage The behavior of the method depends on how large the array that is passed to the method is. The array must have at least two entries. The first entry will contain the number of Owned Extents in the table. The second entry will contain the number of Available Extents in the table. If the array has more than two entries then the remaining bytes of the buffer will consist of an array of structures that represent a list of extents. This structure contains two members: the last page number in the extent and the number of pages in the extent. Use this option with JetGetTableInfo(JET_SESID, JET_TABLEID, [], JET_TblInfo).
SpaceAlloc The array passed to JetGetTableInfo must have two entries. The first entry will be set to the number of pages in the table. The second entry will be set to the target density of pages for the table. Use this option with JetGetTableInfo(JET_SESID, JET_TABLEID, [], JET_TblInfo).
SpaceOwned Gets the number of owned pages in the table. Use this option with JetGetTableInfo(JET_SESID, JET_TABLEID, Int32, JET_TblInfo).
SpaceAvailable Gets the number of available pages in the table. Use this option with JetGetTableInfo(JET_SESID, JET_TABLEID, Int32, JET_TblInfo).
TemplateTableName If the table is a derived table, the result will be filled in with the name of the table from which the derived table inherited its DDL. If the table is not a derived table, the buffer will an empty string. Use this option with JetGetTableInfo(JET_SESID, JET_TABLEID, String, JET_TblInfo).

See also

Reference

Microsoft.Isam.Esent.Interop namespace