table
dqo table import
Import tables from a specified database
Description
Import the tables from the specified database into the application. It allows the user to import the tables from the database into the application for performing various database operations.
Command-line synopsis
$ dqo [dqo options...] table import [-h] [-fw] [-hl] [-c=<connection>] [-of=<outputFormat>]
[-s=<schema>] [-t=<table>]
dqo> table import [-h] [-fw] [-hl] [-c=<connection>] [-of=<outputFormat>]
[-s=<schema>] [-t=<table>]
Options
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection Name | ||
-fw--file-write |
Write command response to a file | ||
-hl--headless |
Run the command in an headless (no user input allowed) mode | ||
-h--help |
Show the help for the command and parameters | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
|
-s--schema |
Schema Name | ||
-t--table |
Table Name |
dqo table edit
Edit table that matches a given condition
Description
Edit the table or tables that match the filter conditions specified in the options. It allows the user to modify the details of an existing table in the application.
Command-line synopsis
$ dqo [dqo options...] table edit [-h] [-fw] [-hl] [-c=<connection>] [-of=<outputFormat>] [-t=<table>]
Options
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection Name | ||
-fw--file-write |
Write command response to a file | ||
-hl--headless |
Run the command in an headless (no user input allowed) mode | ||
-h--help |
Show the help for the command and parameters | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
|
-t--table |
Full table name (schema.table), supports wildcard patterns 'sch.tab' |
dqo table add
Add table with specified name
Description
Add a new table with the specified name to the database. It allows the user to create a new table in the application for performing various operations.
Command-line synopsis
$ dqo [dqo options...] table add [-h] [-fw] [-hl] [-c=<connectionName>] [-of=<outputFormat>]
[-t=<fullTableName>]
Options
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection Name | ||
-fw--file-write |
Write command response to a file | ||
-hl--headless |
Run the command in an headless (no user input allowed) mode | ||
-h--help |
Show the help for the command and parameters | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
|
-t--table |
Table name |
dqo table remove
Remove tables that match a given condition
Description
Remove one or more tables that match a given condition. It allows user to use various filters, such as table names to narrow down the set of tables to remove.
Command-line synopsis
$ dqo [dqo options...] table remove [-h] [-fw] [-hl] [-c=<connectionName>] [-of=<outputFormat>]
[-t=<fullTableName>]
Options
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection Name | ||
-fw--file-write |
Write command response to a file | ||
-hl--headless |
Run the command in an headless (no user input allowed) mode | ||
-h--help |
Show the help for the command and parameters | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
|
-t--table |
Table |
dqo table update
Update tables that match a given condition
Description
Update the structure of one or more tables that match a given condition. It allows user to use various filters, such as table names to narrow down the set of tables to update.
Command-line synopsis
$ dqo [dqo options...] table update [-h] [-fw] [-hl] [-c=<connectionName>] [-n=<newTableName>]
[-of=<outputFormat>] [-t=<fullTableName>]
dqo> table update [-h] [-fw] [-hl] [-c=<connectionName>] [-n=<newTableName>]
[-of=<outputFormat>] [-t=<fullTableName>]
Options
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection Name | ||
-fw--file-write |
Write command response to a file | ||
-hl--headless |
Run the command in an headless (no user input allowed) mode | ||
-h--help |
Show the help for the command and parameters | ||
-n--newTable |
New table name | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
|
-t--table |
Table |
dqo table list
List tables filtered by the given conditions
Description
List all the tables that match a given condition. It allows the user to use various filters, such as table name or schema names to list filtered tables.
Command-line synopsis
$ dqo [dqo options...] table list [-h] [-fw] [-hl] [-c=<connectionName>] [-of=<outputFormat>]
[-t=<tableName>] [-d=<dimensions>]... [-l=<labels>]...
dqo> table list [-h] [-fw] [-hl] [-c=<connectionName>] [-of=<outputFormat>]
[-t=<tableName>] [-d=<dimensions>]... [-l=<labels>]...
Options
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection name | ||
-d--dimension |
Dimension filter | ||
-fw--file-write |
Write command response to a file | ||
-hl--headless |
Run the command in an headless (no user input allowed) mode | ||
-h--help |
Show the help for the command and parameters | ||
-l--label |
Label filter | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
|
-t--table |
Table name filter |