GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
mdb-tables(1) Executable programs or shell commands mdb-tables(1)

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

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

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.

-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.

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)

mdb-tables first appeared in MDB Tools 0.3.

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)

The mdb-tables utility was written by Brian Bruns.

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.
12 April 2022 MDBTools 1.0.0

Search for    or go to Top of page |  Section 1 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.