Anonymous Asked in Cars &Transportation · 2 weeks ago

Which command is used to view the tables in database?

Answer : SHOW TABLES; command is used to view the list of tables in a database. 28 янв. 2022 г.


How can I see tables in database?

MySQL Show/List Tables1Step 1: Open the MySQL Command Line Client that appeared with a mysql> prompt. ... 2Step 2: Next, choose the specific database by using the command below:3Step 3: Finally, execute the SHOW TABLES command.4Output:5Syntax.

What is the command to view tables in SQL?

Using the MySQL Command Line Client mysql> USE pizza_store; Now use the MySQL SHOW TABLES command to list the tables in the chosen database. mysql> SHOW TABLES; This command returns a list of all the tables in the chosen database.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours