esedb-columns

Retrieves a list of column definitions for a table from an Extensible Storage Engine (ESE) database file.

Syntax

esedb-columns table=TABLE FILE_PATH
Required Parameters
FILE_PATH
Path to the ESE database file.
table=TABLE
Name of the table from which to retrieve the column definition list.

Description

After running the esedb-columns command, the output fields are as follows:

Output Fields

FieldTypeDescription
_fileStringFile name
table_nameStringTable name
column_idIntegerColumn identifier
column_nameStringColumn name
column_typeStringColum data type

The column_type field represents one of the following values: bit, unsigned byte, short, unsigned short, long, unsigned long, long long, binary, long binary, or text

Usage

Retrieve the list of columns in the MSysObjects table from the /opt/logpresso/WebCacheV01.dat file.

esedb-columns table=MSysObjects /opt/logpresso/WebCacheV01.dat