View tables in database
Step
To view the tables in a database associated with a database alias, run the following command:
./pdbctl listtables -a <database_user_alias>
Flag Description
The following table describes the flags associated with this command:
| Flag | Data Type | Description |
|---|---|---|
| -a | string | Database alias associated with the database user. |
| -n | int | Number of tables to display. The default value is 100. This is an optional parameter. |
| -h | Flag to view help for listtables command. | |
| -t | string | Name of table for which columns will be listed. |
| -- verbose | Print verbose logs. |
Example
The following sample command lists the tables associated with alias demo:
./pdbctl listtables -a demo -n 10
Here, n is an optional parameter to set the number of tables to be listed in the output.
Output
----------------------------------------
Table name: CUSTOMERS
Table encrypted: false
----------------------------------------
By default, 100 tables will be listed in the search result. The user has option to view either encrypted tables or all tables.
