MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
mdb-tables1
Get listing of tables in an mdb database
Usage
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
Overview
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
-
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)
Releases
11 releases since Debian 3.1 (Sarge); the text changed 9 times.
--delimiter since Debian 11 (Bullseye);
--showtype since Debian 11 (Bullseye);
--single-column since Debian 11 (Bullseye);
--system since Debian 11 (Bullseye);
--type since Debian 11 (Bullseye);
--version since Debian 12 (Bookworm);
-T since Debian 11 (Bullseye);
-t since Debian 11 (Bullseye).