mdb-queries(1)

πŸ’… mdb-queries β€” the manual page, but make it cute

okay bestie, welcome to mdb-queries(1), from the Executable programs or shell commands shelf of your local man cave. it's a lil MDB Tools utility and it's about to spill all the tea on the queries hiding inside your database. let's go 🫢


✨ NAME ✨

mdb-queries β€” Get listing of tables in an MDB database

(that's the official line, verbatim, no notes πŸ’–)


🌸 SYNOPSIS 🌸

mdb-queries [-L] [-1] [-d delim] database query
mdb-queries --version
mdb-queries -h|--help

three moods, three invocation styles. pick your fighter. πŸŽ€


πŸ¦‹ DESCRIPTION πŸ¦‹

so mdb-queries is a utility program that ships with MDB Tools, which, yes, is the whole vibe.

what does it do, you ask? two things, and it does them iconically:

  • it produces a list of queries in the database πŸ—‚οΈ
  • and it dumps the SQL associated with a specific query πŸ’Ύ

that's it. that's the whole job. no cap.


πŸ’… OPTIONS πŸ’…

  • -L, --list β€” List queries in the database. (it's the default if no query name is passed, so honestly she's always working, whether you ask or not πŸ‘‘)
  • -1, --newline β€” Use newline as the delimiter (used in conjunction with listing). one per line, clean, organized, main character energy ✨
  • -d, --delimiter delim β€” Specify delimiter to use (defaults to space). you want commas? pipes? go off, choose your own ✨
  • --version β€” Print the mdbtools version and exit. short, sweet, goodbye πŸ‘‹

πŸ’œ NOTES πŸ’œ

(the original page leaves this one blank, so we're leaving it blank too. sometimes the silence is the statement. πŸ’€)


🌈 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. (compiled with iconv, bestie, not optional, don't come for me 😭)
  • 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) β€” rip, she's retired πŸͺ¦
    • use_index (experimental; requires libmswstr) β€” spicy, unstable, only if you're brave πŸ”₯

πŸ“œ HISTORY πŸ“œ

mdb-queries first appeared in MDB Tools 0.9. a legend from the start, fr fr. ⭐


πŸ‘€ 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)

the whole friend group, all together. 🫢 go say hi.


πŸŽ€ AUTHORS πŸŽ€

The mdb-queries utility was written by Leonard Leblanc. thank you king, we owe you everything πŸ’–


and that's the whole page!! this was MDBTools 1.0.1, dated 13 July 2026 β€” shoutout to the version and the date for holding it down at the bottom of the page. slay, bye πŸ’…βœ¨πŸŒΈ

πŸ“¦ where this page comes from