table of contents
mdb-queries(1) | Executable programs or shell commands | mdb-queries(1) |
NAME¶
mdb-queries - Get listing of tables in an MDB database
SYNOPSIS¶
mdb-queries [-L] [-1] [-d delim] database query mdb-queries --version 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¶
- -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)
- -d, --delimiter delim
- Specify delimiter to use (defaults to space)
- --version
- Print the mdbtools version and exit
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.
- MDBOPTS
- Colon-separated list of options:
- debug_like
- debug_write
- debug_usage
- debug_ole
- debug_row
- debug_props
- debug_all is a shortcut for all debug_* options
- no_memo (deprecated; has no effect)
- use_index (experimental; requires libmswstr)
HISTORY¶
mdb-queries first appeared in MDB Tools 0.9.
SEE ALSO¶
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)
AUTHORS¶
The mdb-queries utility was written by Leonard Leblanc.
03 April 2023 | MDBTools 1.0.0 |