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	delimiter] database

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     Show system tables. System tables	are generally those  beginning
	      with 'MSys'

       -1     specifies	that the tables	should be listed 1 per line.

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

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-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 embeded 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.7.1			 02 July 2017			 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+12.0-RELEASE+and+Ports>

home | help