Please Note:

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>

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.

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.