JET_COLUMNLIST Structure

Applies to: Windows | Windows Server

JET_COLUMNLIST Structure

The JET_COLUMNLIST structure contains the information necessary to traverse the temporary table that is created by the JetGetColumnInfo and JetGetTableColumnInfo functions. Each row in the temporary table describes a column in the table given in the API call. This structure is used with only with JetGetColumnInfo and JetGetTableColumnInfo.

    typedef struct {
      unsigned long cbStruct;
      JET_TABLEID tableid;
      unsigned long cRecord;
      JET_COLUMNID columnidPresentationOrder;
      JET_COLUMNID columnidcolumnname;
      JET_COLUMNID columnidcolumnid;
      JET_COLUMNID columnidcoltyp;
      JET_COLUMNID columnidCountry;
      JET_COLUMNID columnidLangid;
      JET_COLUMNID columnidCp;
      JET_COLUMNID columnidCollate;
      JET_COLUMNID columnidcbMax;
      JET_COLUMNID columnidgrbit;
      JET_COLUMNID columnidDefault;
      JET_COLUMNID columnidBaseTableName;
      JET_COLUMNID columnidBaseColumnName;
      JET_COLUMNID columnidDefinitionName;
    } JET_COLUMNLIST;

Members

cbStruct

The size of the structure in bytes. The API call will update this field, so the caller should ensure that this value matches sizeof( JET_COLUMNLIST ).

tableid

The table identifier of the temporary table that was created. It is the responsibility of the caller to close the table.

cRecord

The number of records in the temporary table that was created by the API call.

columnidPresentationOrder

The column identifier of the presentation order.

The presentation order is used to sort the rows of the temporary table. The presentation order is a fixed JET_coltypLong. If the information level that was specified was not a compact level, then it is also marked as JET_bitColumnTTKey.

columnidcolumnname

The column identifier of the name of the column.

If the information level specified was not compact, then it is also marked as JET_bitColumnTTKey.

columnidcolumnid

The column identifier of the column identifier.

The column identifier is a fixed JET_coltypLong.

columnidcoltyp

The column identifier of the column type.

The column type is a fixed JET_coltypLong.

columnidCountry

The column identifier of the country code.

The country code is a fixed JET_coltypShort.

columnidLangid

The column identifier of the language identifier.

The language identifier is a fixed JET_coltypShort.

columnidCp

The column identifier of the code page.

The code page is a fixed JET_coltypShort.

columnidCollate

The column identifier of the collation sequence.

The collation sequence is a fixed JET_coltypShort.

columnidcbMax

The column identifier of the cbMax field.

The cbMax is a fixed JET_coltypLong.

columnidgrbit

The column identifier of the grbits of the column. The grbit field is a fixed JET_coltypLong. For more information about these bits, see JET_COLUMNDEF.

The following are possible values for columnidgrbit:

JET_bitColumnTagged

JET_bitColumnFixed

JET_bitColumnUpdatable

JET_bitColumnNotNULL

JET_bitColumnAutoincrement

JET_bitColumnVersion

JET_bitColumnMultiValued

JET_bitColumnEscrowUpdate

JET_bitColumnFinalize

JET_bitColumnDeleteOnZero

JET_bitColumnUserDefinedDefault

columnidDefault

The column identifier of the default value of the column.

The default value is a JET_coltypLongBinary.

columnidBaseTableName

The column identifier of the name of the table from which the table was derived.

The table name is a JET_coltypText.

columnidBaseColumnName

The column identifier of the name of the column from which the column was derived.

The column name is a JET_coltypText.

columnidDefinitionName

The column identifier of the name of the column definition.

The column definition name is a JET_coltypText.

Remarks

By default, the order of the rows in the temporary table is sorted by the name of the column. It can also be sorted by column identifier. For more information about how to sort by column identifier, see JetGetColumnInfo and JetGetTableColumnInfo.

The call to JetGetColumnInfo or JetGetTableColumnInfo might specify a compact form of results. If any columns have been inherited from a template table, the compact results will not store them.

Requirements

See Also

JET_COLTYP

JET_COLUMNDEF

JET_COLUMNID

JET_ERR

JET_GRBIT

JET_SESID

JET_TABLEID

JetGetColumnInfo

JetGetTableColumnInfo