Your company here, and a link to your site. Click to find out more.

mdb-tables - Man Page

Get listing of tables in an MDB database


mdb-tables [-S] [-1 | -d delim] [-t form|table|macro|systable|report|query|linkedtable|module|relationship|dbprop|any|all] [-T] database
mdb-tables -h|--help
mdb-tables --version


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.


-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,  --delimiter delim

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,  --type type

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.


Print the mdbtools version and exit.




Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).


Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.


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)


mdb-tables first appeared in MDB Tools 0.3.

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)


The mdb-tables utility was written by Brian Bruns.


Access allows for tables to have spaces embedded in the table name.

You must specify a delimiter (-d) if you intend on piping the output of mdb-tables to a program such as awk or cut.

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-queries(1), mdb-schema(1), mdb-sql(1), mdb-ver(1).

20 July 2023 MDBTools 1.0.0 Executable programs or shell commands