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

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.

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
	      semi-column separated list of options:

	      o	 use_index

	      o	 no_memo

	      o	 debug_like

	      o	 debug_write

	      o	 debug_usage

	      o	 debug_ole

	      o	 debug_row

	      o	 debug_props

	      o	 debug_all is a	shortcut for all debug_* options

HISTORY
       mdb-tables first	appeared in MDB	Tools 0.3.

SEE ALSO
       gmdb2(1)	mdb-export(1) mdb-hexdump(1)  mdb-import(1)  mdb-prop(1)  mdb-
       sql(1)	mdb-ver(1)  mdb-array(1)  mdb-header(1)	 mdb-parsecsv(1)  mdb-
       schema(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 0.8.2		       28 February 2021			 mdb-tables(1)

NAME | SYNOPSIS | DESCRIPTION | OPTIONS | NOTES | ENVIRONMENT | HISTORY | SEE ALSO | AUTHORS | BUGS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=mdb-tables&sektion=1&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help