EnglishFrenchSpanish

Ad


OnWorks favicon

mdb-schema - Online in the Cloud

Run mdb-schema in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command mdb-schema that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

PROGRAM:

NAME


mdb-schema - Generate schema creation DDL

SYNOPSIS


mdb-schema [options] database [backend]

DESCRIPTION


mdb-schema is a utility program distributed with MDB Tools.

It produces DDL (data definition language) output for the given database. This can be
passed to another database to create a replica of the original access table format.

OPTIONS


-T <table>, --table <table>
Single table option. Create schema for this table only. Default is to export all
tables.

-N namespace
Prefix identifiers with namespace.

--drop-table
Issue DROP TABLE statement.

--no-drop-table
Don't issue DROP TABLE statement. This is the default.

--not-null
Issue NOT NULL constraints. This is the default.

--no-not-null
Don't issue NOT NULL constraints.

--default-values
Issue DEFAULT values.

--no-default-values
Don't issue DEFAULT values. This is the default.

--not-empty
Issue CHECK <> '' constraints.

--no-not-empty
Don't issue CHECK <> '' constraints. This is the default.

--indexes
Export INDEXes. This is the default.

--no-indexes
Don't export INDEXes.

--relations
Export foreign keys constraints. This is the default.

--no-relations
Don't export foreign keys constraints.

backend
Specifies target DDL dialect. Supported values are access, sybase, oracle,
postgres, mysql and sqlite. If not specified the generated DDL will be in access
format.

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 to use for the SQL file. Default is UTF-8. mdbtools must
have been compiled with iconv.

MDBOPTS
semi-column separated list of options:

· use_index

· no_memo

· debug_like

· debug_write

· debug_usage

· debug_ole

· debug_row

· debug_props

· debug_all is a shortcut for all debug_* options

NOTES


HISTORY


mdb-schema first appeared in MDB Tools 0.1.

Use mdb-schema online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    fre:ac - free audio converter
    fre:ac - free audio converter
    fre:ac is a free audio converter and CD
    ripper for various formats and encoders.
    It features MP3, MP4/M4A, WMA, Ogg
    Vorbis, FLAC, AAC, and Bonk format
    support, ...
    Download fre:ac - free audio converter
  • 2
    Matplotlib
    Matplotlib
    Matplotlib is a comprehensive library
    for creating static, animated, and
    interactive visualizations in Python.
    Matplotlib makes easy things easy and
    hard thing...
    Download Matplotlib
  • 3
    BotMan
    BotMan
    Write your chatbot logic once and
    connect it to one of the available
    messaging services, including Amazon
    Alexa, Facebook Messenger, Slack,
    Telegram or even yo...
    Download BotMan
  • 4
    Joplin
    Joplin
    Joplin is a free and open source
    note-taking and to-do application that
    can handle a large number of notes in
    Markdown format, organize them into
    notebooks and...
    Download Joplin
  • 5
    gerbv  a Gerber (RS-274X) viewer
    gerbv � a Gerber (RS-274X) viewer
    Gerbv is an open source Gerber file
    (RS-274X only) viewer. Gerbv lets you
    load several files on top of each other,
    do measurements on the displayed image,
    etc. ...
    Download gerbv � a Gerber (RS-274X) viewer
  • 6
    Iometer
    Iometer
    I/O performance Analysis Tool.
    Audience: Developers, Information
    Technology, Science/Research, System
    Administrators. User interface: Win32
    (MS Windows). Progr...
    Download Iometer
  • More »

Linux commands

Ad