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

NAME

6       mdb-schema - Generate schema creation DDL
7

SYNOPSIS

9       mdb-schema [options] database [backend]
10
11

DESCRIPTION

13       mdb-schema is a utility program distributed with MDB Tools.
14
15       It  produces  DDL (data definition language) output for the given data‐
16       base. This can be passed to another database to create a replica of the
17       original access table format.
18

OPTIONS

20       -T <table>, --table <table>
21              Single table option.  Create schema for this table only. Default
22              is to export all tables.
23
24       -N namespace
25              Prefix identifiers with namespace.
26
27       --drop-table
28              Issue DROP TABLE statement.
29
30       --no-drop-table
31              Don't issue DROP TABLE statement. This is the default.
32
33       --not-null
34              Issue NOT NULL constraints. This is the default.
35
36       --no-not-null
37              Don't issue NOT NULL constraints.
38
39       --default-values
40              Issue DEFAULT values.
41
42       --no-default-values
43              Don't issue DEFAULT values. This is the default.
44
45       --not-empty
46              Issue CHECK <> '' constraints.
47
48       --no-not-empty
49              Don't issue CHECK <> '' constraints. This is the default.
50
51       --indexes
52              Export INDEXes. This is the default.
53
54       --no-indexes
55              Don't export INDEXes.
56
57       --relations
58              Export foreign keys constraints. This is the default.
59
60       --no-relations
61              Don't export foreign keys constraints.
62
63       backend
64              Specifies target  DDL  dialect.  Supported  values  are  access,
65              sybase, oracle, postgres, mysql and sqlite. If not specified the
66              generated DDL will be in access format.
67

ENVIRONMENT

69       MDB_JET3_CHARSET
70              Defines the charset of the input JET3 (access 97) file.  Default
71              is CP1252. See iconv(1).
72
73       MDBICONV
74              Defines  the  output charset to use for the SQL file. Default is
75              UTF-8. mdbtools must have been compiled with iconv.
76
77       MDBOPTS
78              semi-column separated list of options:
79
80              •  use_index
81
82              •  no_memo
83
84              •  debug_like
85
86              •  debug_write
87
88              •  debug_usage
89
90              •  debug_ole
91
92              •  debug_row
93
94              •  debug_props
95
96              •  debug_all is a shortcut for all debug_* options
97

NOTES

HISTORY

100       mdb-schema first appeared in MDB Tools 0.1.
101

SEE ALSO

103       gmdb2(1) mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1)
104       mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-tables(1)
105

AUTHORS

107       The mdb-schema utility was written by Brian Bruns and others.
108

BUGS

110       Relationships and other features may not be supported by all databases.
111       Access datatypes are mapped to their closest counterparts in the target
112       backend. This may not always yield an exact fit.
113
114
115
116MDBTools 0.7.1                  26 January 2021                  mdb-schema(1)
Impressum