1untitled(January 31, 2006)                          untitled(January 31, 2006)
2
3
4

NAME

6       mdb-schema - Generate schema creation DDL
7

SYNOPSIS

9       mdb-schema [-N <namespace>] [-S] [-T <table>] <database> [<backend>]
10

DESCRIPTION

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

OPTIONS

19       -N     Prefix identifiers with namespace
20
21       -S     Sanitize names (replace spaces etc. with underscore)
22
23       -T     Single table option.  Create schema for this table only.
24
25       backend
26              Specifies  target  DDL  dialect.  Supported  values  are access,
27              sybase, oracle, and postgres. If not specified the generated DDL
28              will be in access format.
29

NOTES

HISTORY
32       mdb-schema first appeared in MDB Tools 0.1
33

AUTHORS
35       The mdb-schema utility was written by Brian Bruns
36

BUGS
38       Relationships and other features may not be supported by all databases.
39       Access datatypes are mapped to their closest counterparts in the target
40       backend. This may not always yield an exact fit.
41
42
43
44                                                    untitled(January 31, 2006)



        

    


            
        

        

            Impressum