Questions
2 of 13
1How to create tables?
2How to list tables in a database?
3How to modify the structure of a table?
4How to rename a table?
5How to clone tables in mysql?
6How to truncate a table?
7What are Temporary Tables?
8How do we repair tables?
9how to add and delete columns in an existing table?
10How to get information about the table?
11How to lock tables and why do we need to lock a table?
12How to drop a table?
13What are derived tables?
mysqlmysql
Basics
Databases
Tables
Data Types
Queries
Views
Indexes
Clauses
Regex
Functions and Operators
Keys
Joins
Triggers
02 / 13

How to list tables in a database?

We use the SHOW TABLES command to retrieve the names of tables that are present in a specific database.

Query:
Share

Share via WhatsApp, X, Facebook, LinkedIn or copy link. Open Graph preview enabled.