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 Parameter
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
Field | Type | Description |
---|---|---|
_file | String | File name |
table_name | String | Table name |
column_id | Integer | Column identifier |
column_name | String | Column name |
column_type | String | Colum 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