1mdb-tables(1)        Executable programs or shell commands       mdb-tables(1)
2
3
4

NAME

6       mdb-tables - Get listing of tables in an MDB database
7

SYNOPSIS

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

DESCRIPTION

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

OPTIONS

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

NOTES

ENVIRONMENT

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

HISTORY

77       mdb-tables first appeared in MDB Tools 0.3.
78

SEE ALSO

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

AUTHORS

85       The mdb-tables utility was written by Brian Bruns.
86

BUGS

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 1.0.0                   20 July 2023                    mdb-tables(1)
Impressum