mdb-queries - Man Page

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.

Referenced By

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).

18 July 2024 MDBTools 1.0.0 Executable programs or shell commands