mdb-queries(1)

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.

26 December 2024 MDBTools 1.0.1