Skip to content

meta database ddl

meta database ddl - get the DDL statement for a database in dbvr.

Synopsis

dbvr meta database ddl [-hV]
                       [-db=<databaseName>]
                       [--full]
                       [-p=<dbPassword>]
                       [--project=<projectIdOrName>]
                       [-u=<dbUser>]
                       [-auth=<authParams>]...
                       [-ext=<providerParams>]...
                       [-prop=<connectionParams>]...
                       [[-net=<handlerParams>]...
                        [-net-save-pwd=<savePassword>]]
                       (-ds=<existDataSourceIdOrName> |
                        -con=<connectionSpec> |
                        [--driver=<driver>
                          [[--auth-model=<authModel>]
                           [--folder=<folder>]
                           [--name=<dataSourceName>]
                           [--save-password=<savePassword>]
                           [--url=<url> |
                            [[--host=<host>]
                             [--database=<dbName>]
                             [--server=<server>]
                             [--port=<port>]]]]])

Tip

You can also use global options with this command.

Description

Get the DDL statement for a database (catalog).

Connection options

Use connection settings to specify which database this command runs against.

Connect in one of these ways:

  • use an existing datasource with -ds or --datasource
  • provide a full connection specification with -con, -ds-spec, -connect, or --datasource-specification
  • define a connection inline with --driver and connection parameters

Include credentials, network handlers, and driver-specific properties if required.

Info

For details on all connection settings, see Connection options.

Options

--database-name

-db, --database-name=<databaseName>

Database to get DDL for. Defaults to the connection database if omitted.

--full

--full

Include extended properties in the DDL output.

--project

--project=<projectIdOrName>

Use a datasource from the specified project.

Tip

Run project list to see available projects.

Example

dbvr meta database ddl -ds=mysql-local -db=testdb