meta table list

meta table list - list tables available in a connected datasource.

Synopsis

dbvr meta table list [-hV]
                     [-db=<databaseName>]
                     [-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

List tables available in a connected datasource.

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>

Scope the listing to a specific database (catalog). Required on most databases.

--schema-name

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

Scope the listing to a specific schema. Required on most databases.

--project

--project=<projectIdOrName>

Use a datasource from the specified project.

Tip

Run project list to see available projects.

Example

dbvr meta table list -ds=pg-local -db=testdb -sn=public

Sample output:

customers
orders
order_items
products

List tables using inline connection parameters:

dbvr meta table list \
  --driver=postgres-jdbc \
  --host=localhost \
  --port=5432 \
  --database=testdb \
  -u=admin \
  -p=password \
  -db=testdb \
  -sn=public