meta table ddl

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

Synopsis

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

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 (catalog) that contains the table.

--schema-name

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

Schema that contains the table.

--table-name

-tn, --table-name=<tableName>

Table 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 table ddl -ds=pg-local -db=testdb -sn=public -tn=orders

Sample output:

-- Drop table

-- DROP TABLE public.orders;

CREATE TABLE public.orders (
    id integer NOT NULL,
    customer_id integer,
    created_at timestamp without time zone,
    total numeric(10,2),
    CONSTRAINT orders_pkey PRIMARY KEY (id)
);

Get full DDL including indexes:

dbvr meta table ddl -ds=pg-local -db=testdb -sn=public -tn=orders --full

Tip

On databases with a catalog hierarchy (PostgreSQL, SQL Server, etc.), both -db and -sn are required. On Oracle, only -sn is needed. On flat databases like SQLite, both can be omitted.