mdb-tables(1) Executable programs or shell commands mdb-tables(1) 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, rela- tionship, 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). 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-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) 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. MDBTools 1.0.1 27 August 2026 mdb-tables(1)
NAME | SYNOPSIS | DESCRIPTION | OPTIONS | NOTES | ENVIRONMENT | HISTORY | SEE ALSO | AUTHORS | BUGS
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=mdb-tables&sektion=1&manpath=FreeBSD+Ports+15.1.quarterly>