Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
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 for-
       mat 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	speci-
	      fied, 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,  mod-
	      ule, 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
       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			 12 April 2025			 mdb-tables(1)

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+14.3.quarterly>

home | help