2020-10-21 18:48:20 +08:00
|
|
|
NAME
|
|
|
|
|
mdb-queries - Get listing of tables in an MDB database
|
|
|
|
|
|
|
|
|
|
SYNOPSIS
|
|
|
|
|
mdb-queries [-L] [-1] [-d delim] database query
|
2021-01-20 09:37:25 +08:00
|
|
|
mdb-queries --version
|
2020-10-21 18:48:20 +08:00
|
|
|
mdb-queries -h|--help
|
|
|
|
|
|
|
|
|
|
DESCRIPTION
|
|
|
|
|
mdb-queries is a utility program distributed with MDB Tools.
|
|
|
|
|
|
|
|
|
|
It produces a list of queries in the database, and dump the SQL associated with a specific query.
|
|
|
|
|
|
|
|
|
|
OPTIONS
|
2021-01-20 05:27:36 +08:00
|
|
|
-L, --list List queries in the database (default if no query name is passed)
|
|
|
|
|
-1, --newline Use newline as the delimiter (used in conjunction with listing)
|
2021-01-20 09:37:25 +08:00
|
|
|
-d, --delimiter delim Specify delimiter to use (defaults to space)
|
|
|
|
|
--version Print the mdbtools version and exit
|
2020-10-21 18:48:20 +08:00
|
|
|
|
|
|
|
|
NOTES
|
|
|
|
|
|
|
|
|
|
ENVIRONMENT
|
|
|
|
|
MDB_JET3_CHARSET Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
|
|
|
|
|
MDBICONV Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.
|
2021-01-20 05:27:36 +08:00
|
|
|
MDBOPTS Colon-separated list of options:
|
2020-10-21 18:48:20 +08:00
|
|
|
* debug_like
|
|
|
|
|
* debug_write
|
|
|
|
|
* debug_usage
|
|
|
|
|
* debug_ole
|
|
|
|
|
* debug_row
|
|
|
|
|
* debug_props
|
|
|
|
|
* debug_all is a shortcut for all debug_* options
|
2021-01-20 05:27:36 +08:00
|
|
|
* no_memo (deprecated; has no effect)
|
|
|
|
|
* use_index (experimental; requires libmswstr)
|
2020-10-21 18:48:20 +08:00
|
|
|
|
|
|
|
|
HISTORY
|
|
|
|
|
mdb-queries first appeared in MDB Tools 0.9.
|
|
|
|
|
|
|
|
|
|
SEE ALSO
|
2020-10-23 18:53:41 +08:00
|
|
|
mdb-array(1) mdb-count(1) mdb-export(1) mdb-header(1) mdb-hexdump(1)
|
|
|
|
|
mdb-import(1) mdb-json(1) mdb-parsecsv(1) mdb-prop(1)
|
|
|
|
|
mdb-schema(1) mdb-sql(1) mdb-tables(1) mdb-ver(1)
|
2020-10-21 18:48:20 +08:00
|
|
|
|
|
|
|
|
AUTHORS
|
|
|
|
|
The mdb-queries utility was written by Leonard Leblanc.
|
