Me gusta 0

list

NAME

list - display databases, schemas, tables or views defined in a database server

SYNOPSIS

list database
list [-h] databases
list [-d DATABASE] [-h] schemas
list [-d DATABASE] [-h] [-s SCHEMA] tables
list [-d DATABASE] [-h] [-s SCHEMA] views

DESCRIPTION

list shows currently connected database or displays the list of databases, schemas, tables or views defined in the connected RDBMS server. The connection to the RDBMS server needs to be established before the list command is executed.

When a list of databases is displayed, an asterisk character, '*', is appended to the name of the currently connected database. Depends on the connected RDBMS server, a database name and/or a schema name might be required to list schemas, tables or views. Please see Aqua Open APIs documentation for more information.

OPTIONS

-d DATABASE
The name of the database from which to look up data, default to the currently connected database.

-h
Display output with headers; headers are not shown by default.

-s SCHEMA
The name of the schema from which to look up data, default to the currently connected schema.

EXAMPLES

To list the databases in a server use the command:

list databases

To list the databases with headers use the -h option

list -h databases

To list the schemas of a purticular database use the -d option together with schemas keyword:

list -d AQUAFOLD -h schemas

To list all the tables of a database:

list -d AQUAFOLD -h tables

To list all the views of a database:

list -d AQUAFOLD -h views

NOTES

-d: does not work on SQLite

-s: does not work on SQLite

SEE ALSO

change
describe
connect

Comentarios (0) Datos adjuntos (0)

Esta lista está vacía.

Consejos de búsqueda

Aqua Data Studio / nhilam

list

Consejos de búsqueda

Aqua Data Studio / nhilam

Title

list