---
name: "mdb-tables"
section: "1"
platform: "linux"
package: "mdbtools"
version: "1.0.1-0.1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/mdb-tables"
---

# mdb-tables(1)

Get listing of tables in an MDB database

## NAME

**mdb-tables** - Get listing of tables in an MDB database

## SYNOPSIS

```
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
```

## 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.**

## 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, --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.**

- **--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)](/iconv/1.md).**

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

## SEE ALSO

**[mdb-array(1)](/mdb-array/1.md) [mdb-count(1)](/mdb-count/1.md) [mdb-export(1)](/mdb-export/1.md) [mdb-header(1)](/mdb-header/1.md) [mdb-hexdump(1)](/mdb-hexdump/1.md)** **[mdb-import(1)](/mdb-import/1.md) [mdb-json(1)](/mdb-json/1.md) [mdb-parsecsv(1)](/mdb-parsecsv/1.md) [mdb-prop(1)](/mdb-prop/1.md) [mdb-queries(1)](/mdb-queries/1.md)** **[mdb-schema(1)](/mdb-schema/1.md) [mdb-sql(1)](/mdb-sql/1.md) [mdb-ver(1)](/mdb-ver/1.md)**

## AUTHORS

**The mdb-tables utility was written by Brian Bruns.**

## BUGS

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