meta schema ddl

Table of contents

• Synopsis
• Description
• Connection options
• Options
  • --database-name
  • --schema-name
  • --full
  • --project
• Example

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

Synopsis

dbvr meta schema ddl [-hV]
                     [-db=<databaseName>]
                     [--full]
                     [-p=<dbPassword>]
                     [--project=<projectIdOrName>]
                     -sn=<schemaName>
                     [-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 schema.

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.

For details on all connection settings, see Connection options.

Options

--database-name

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

Database (catalog) that contains the schema.

--schema-name

-sn, --schema-name=<schemaName>

Schema to retrieve the DDL for.

--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 schema ddl -ds=pg-local -db=testdb -sn=public

Sample output:

-- DROP SCHEMA public;

CREATE SCHEMA public AUTHORIZATION admin;