mdb-tables - Get listing of tables in an MDB database
Contents
Bugs
Accessallowsfortablestohavespacesembeddedinthetablename.
You must specify a delimiter (-d) if you intend on piping the output of mdb-tables to a program
such as awk or cut.
MDBTools 1.0.1 05 January 2025 mdb-tables(1)
Description
mdb-tables is a utility program distributed with MDB Tools.
It produces a list of tables contained within an MDB database in a format suitable for use in shell
scripts.
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-tables first appeared in MDB Tools 0.3.
Name
mdb-tables - Get listing of tables in an MDB database
Notes
Options
-S,--system
Show system tables. System tables are generally those beginning with 'MSys'.
-1,--single-column
Specifies that the tables should be listed 1 per line. This is equivalent to --delim 0
-d,--delimiterdelim
Specifies an alternative delimiter. If no delimiter is specified, table names will be delimited by
a tab character, or by newline if the -1 option was specified.
-t,--typetype
Filters entries to show alternate types. Autorized values are form, table, macro, systable,
report, query, linkedtable, module, relationship, dbprop, any, and all. Default value is table.
-T,--showtype
Display the entry type indentifier before each entry.
--version
Print the mdbtools version and exit.
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-queries(1) mdb-schema(1) mdb-sql(1) mdb-ver(1)
Synopsis
mdb-tables [-S] [-1 | -ddelim] [-t form|table|macro|systable|report|query|linkedtable|module|relationship|dbprop|any|all] [-T] databasemdb-tables-h|--helpmdb-tables--version
