• Html
  • CSS
  • JavaScript
  • DBMS & MySQL
  • PL/SQL

Popular Tutorials

  • Html
  • CSS
  • JavaScript

Popular Exercises

Learn DBMS and MySQL

Tutorials QNA

Our tutorial provides basic and advance concepts of database management and MySQL commands with detailed examples

Page Index

DBMS Introduction
MySQL Database
MySQL Tables
MySQL Queries
MySQL Clauses
MySQL Conditions
MySQL Keys

MySQL Show tables

The show or list table is very important when we have many databases that contain various tables. Sometimes the table names are the same in many databases; in that case, this query is very useful. We can get the number of table information of a database using the following statement: 

SHOW TABLES;

For example :

Let's move on to Rename table command in MySQL

Previous

MySQL Alter table

Next :

MySQL Rename table

Share this page on :

© 2022 AnalyzeCode.com All rights reserved.