.\" Text automatically generated by txt2man
.TH mdb-tables 1 "03 February 2024" "MDBTools 1.0.0" "Executable programs or shell commands"
.SH NAME
\fBmdb-tables \fP- Get listing of tables in an MDB database
\fB
.SH SYNOPSIS
.nf
.fam C
\fBmdb-tables\fP [\fB-S\fP] [\fB-1\fP | \fB-d\fP \fIdelim\fP] [\fB-t\fP form|table|macro|systable|report|query|linkedtable|module|relationship|dbprop|any|all] [\fB-T\fP] \fIdatabase\fP
\fBmdb-tables\fP \fB-h\fP|\fB--help\fP
\fBmdb-tables\fP \fB--version\fP

.fam T
.fi
.fam T
.fi
.SH DESCRIPTION
\fBmdb-tables\fP is a utility program distributed with MDB Tools. 
.PP
It produces a list of tables contained within an MDB \fIdatabase\fP in a format suitable for use in shell scripts.
.SH OPTIONS
.TP
.B
\fB-S\fP, \fB--system\fP
Show system tables. System tables are generally those beginning with 'MSys'.
.TP
.B
\fB-1\fP, \fB--single-column\fP
Specifies that the tables should be listed 1 per line. This is equivalent to --\fIdelim\fP \n.
.TP
.B
\fB-d\fP, \fB--delimiter\fP \fIdelim\fP
Specifies an alternative delimiter. If no delimiter is specified, table names will be delimited by a tab character, or by newline if the \fB-1\fP option was specified.
.TP
.B
\fB-t\fP, \fB--type\fP 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.
.TP
.B
\fB-T\fP, \fB--showtype\fP
Display the entry type indentifier before each entry.
.TP
.B
\fB--version\fP
Print the mdbtools version and exit.
.SH NOTES 

.SH ENVIRONMENT
.TP
.B
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See \fBiconv\fP(1).
.TP
.B
MDBICONV
Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.
.TP
.B
MDBOPTS
Colon-separated list of options:
.RS
.IP \(bu 3
debug_like
.IP \(bu 3
debug_write
.IP \(bu 3
debug_usage
.IP \(bu 3
debug_ole
.IP \(bu 3
debug_row
.IP \(bu 3
debug_props
.IP \(bu 3
debug_all is a shortcut for all debug_* options
.IP \(bu 3
no_memo (deprecated; has no effect)
.IP \(bu 3
use_index (experimental; requires libmswstr)
.SH HISTORY
\fBmdb-tables\fP first appeared in MDB Tools 0.3.
.SH SEE ALSO
\fBmdb-array\fP(1) \fBmdb-count\fP(1) \fBmdb-export\fP(1) \fBmdb-header\fP(1) \fBmdb-hexdump\fP(1)
\fBmdb-import\fP(1) \fBmdb-json\fP(1) \fBmdb-parsecsv\fP(1) \fBmdb-prop\fP(1) \fBmdb-queries\fP(1)
\fBmdb-schema\fP(1) \fBmdb-sql\fP(1) \fBmdb-ver\fP(1)
.SH AUTHORS
The \fBmdb-tables\fP utility was written by Brian Bruns.
.SH BUGS
.TP
.B
Access allows for tables to have spaces embedded in the table name.
You must specify a delimiter (\fB-d\fP) if you intend on piping the output of \fBmdb-tables\fP to a program such as awk or cut.