Sqoop List Tables - Sqoop

How to list out the tables?

Sqoop List tables explain how to list out the tables of a particular database in MySQL database server using Sqoop. Sqoop list-tables tool parses and executes the ‘SHOW TABLES’ query against a particular database. Thereafter, it shows the present tables in a database.

Syntax

Below mentioned syntax is used for Sqoop list-tables command.

Sample Query

The following command is used to list all the tables in the userdb database of MySQL database server.
After the executing the above code, then it will display the list of tables in the userdb database as follows.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Sqoop Topics