1mdb-tables(1) Executable programs or shell commands mdb-tables(1)
2
3
4
6 mdb-tables - Get listing of tables in an MDB database
7
9 mdb-tables [-S] [-1 | -d delim] [-t form|table|macro|systable|report|query|linkedtable|module|relationship|dbprop|any|all] [-T] database
10 mdb-tables -h|--help
11 mdb-tables --version
12
13
15 mdb-tables is a utility program distributed with MDB Tools.
16
17 It produces a list of tables contained within an MDB database in a for‐
18 mat suitable for use in shell scripts.
19
21 -S, --system
22 Show system tables. System tables are generally those beginning
23 with 'MSys'.
24
25 -1, --single-column
26 Specifies that the tables should be listed 1 per line. This is
27 equivalent to --delim 0
28
29 -d, --delimiter delim
30 Specifies an alternative delimiter. If no delimiter is speci‐
31 fied, table names will be delimited by a tab character, or by
32 newline if the -1 option was specified.
33
34 -t, --type type
35 Filters entries to show alternate types. Autorized values are
36 form, table, macro, systable, report, query, linkedtable, mod‐
37 ule, relationship, dbprop, any, and all. Default value is table.
38
39 -T, --showtype
40 Display the entry type indentifier before each entry.
41
42 --version
43 Print the mdbtools version and exit.
44
47 MDB_JET3_CHARSET
48 Defines the charset of the input JET3 (access 97) file. Default
49 is CP1252. See iconv(1).
50
51 MDBICONV
52 Defines the output charset. Default is UTF-8. mdbtools must have
53 been compiled with iconv.
54
55 MDBOPTS
56 Colon-separated list of options:
57
58 • debug_like
59
60 • debug_write
61
62 • debug_usage
63
64 • debug_ole
65
66 • debug_row
67
68 • debug_props
69
70 • debug_all is a shortcut for all debug_* options
71
72 • no_memo (deprecated; has no effect)
73
74 • use_index (experimental; requires libmswstr)
75
77 mdb-tables first appeared in MDB Tools 0.3.
78
80 mdb-array(1) mdb-count(1) mdb-export(1) mdb-header(1) mdb-hexdump(1)
81 mdb-import(1) mdb-json(1) mdb-parsecsv(1) mdb-prop(1) mdb-queries(1)
82 mdb-schema(1) mdb-sql(1) mdb-ver(1)
83
85 The mdb-tables utility was written by Brian Bruns.
86
88 Access allows for tables to have spaces embedded in the table name.
89 You must specify a delimiter (-d) if you intend on piping the
90 output of mdb-tables to a program such as awk or cut.
91
92
93
94MDBTools 0.9.3 22 July 2021 mdb-tables(1)