1mdb-schema(1) Executable programs or shell commands mdb-schema(1)
2
3
4
6 mdb-schema - Generate schema creation DDL
7
9 mdb-schema [options] [-T tablename] [-N prefix] database [backend]
10 mdb-schema -h|--help
11 mdb-schema --version
12
13
15 mdb-schema is a utility program distributed with MDB Tools.
16
17 It produces DDL (data definition language) output for the given data‐
18 base. This can be passed to another database to create a replica of the
19 original access table format.
20
22 -T, --table tablename
23 Single table option. Create schema for this table only. Default
24 is to export all tables.
25
26 -N, --namespace prefix
27 Prefix identifiers with namespace.
28
29 --drop-table
30 Issue DROP TABLE statement.
31
32 --no-drop-table
33 Don't issue DROP TABLE statement. This is the default.
34
35 --not-null
36 Issue NOT NULL constraints. This is the default.
37
38 --no-not-null
39 Don't issue NOT NULL constraints.
40
41 --default-values
42 Issue DEFAULT values.
43
44 --no-default-values
45 Don't issue DEFAULT values. This is the default.
46
47 --not-empty
48 Issue CHECK <> '' constraints.
49
50 --no-not-empty
51 Don't issue CHECK <> '' constraints. This is the default.
52
53 --comments
54 Issue COMMENT ON statements with column/table descriptions. This
55 is the default, but it's not supported by all backends.
56
57 --no-comments
58 Don't issue COMMENT ON statements.
59
60 --indexes
61 Export INDEXes. This is the default.
62
63 --no-indexes
64 Don't export INDEXes.
65
66 --relations
67 Export foreign keys constraints. This is the default.
68
69 --no-relations
70 Don't export foreign keys constraints.
71
72 --version
73 Print the mdbtools version and exit.
74
75 backend
76 Specifies target DDL dialect. Supported values are access,
77 sybase, oracle, postgres, mysql and sqlite. If not specified the
78 generated DDL will be in access format.
79
81 MDB_JET3_CHARSET
82 Defines the charset of the input JET3 (access 97) file. Default
83 is CP1252. See iconv(1).
84
85 MDBICONV
86 Defines the output charset to use for the SQL file. Default is
87 UTF-8. mdbtools must have been compiled with iconv.
88
89 MDBOPTS
90 Colon-separated list of options:
91
92 • debug_like
93
94 • debug_write
95
96 • debug_usage
97
98 • debug_ole
99
100 • debug_row
101
102 • debug_props
103
104 • debug_all is a shortcut for all debug_* options
105
106 • no_memo (deprecated; has no effect)
107
108 • use_index (experimental; requires libmswstr)
109
112 mdb-schema first appeared in MDB Tools 0.1.
113
115 mdb-array(1) mdb-count(1) mdb-export(1) mdb-header(1) mdb-hexdump(1)
116 mdb-import(1) mdb-json(1) mdb-parsecsv(1) mdb-prop(1) mdb-queries(1)
117 mdb-sql(1) mdb-tables(1) mdb-ver(1)
118
120 The mdb-schema utility was written by Brian Bruns and others.
121
123 Relationships and other features may not be supported by all databases.
124 Access datatypes are mapped to their closest counterparts in the target
125 backend. This may not always yield an exact fit.
126
127
128
129MDBTools 0.9.3 21 July 2022 mdb-schema(1)