🎓 Top 15 Udemy Courses (80-90% Discount): My Udemy Courses - Ramesh Fadatare — All my Udemy courses are real-time and project oriented courses.
▶️ Subscribe to My YouTube Channel (178K+ subscribers): Java Guides on YouTube
▶️ For AI, ChatGPT, Web, Tech, and Generative AI, subscribe to another channel: Ramesh Fadatare on YouTube
Introduction
In this chapter, we will learn how to list all the tables in a MySQL database. This is useful for quickly seeing what tables are available and verifying that tables have been created correctly. We will cover the syntax and examples for using the SHOW TABLES statement.
Showing All Tables
To display all the tables in the current database, we use the SHOW TABLES statement. This command lists all tables in the selected database.
Syntax
SHOW TABLES;
Example
SHOW TABLES;
Output
| Tables_in_database_name |
|---|
| employees |
| departments |
| projects |
This output shows the names of all tables in the current database.
Full Example
Let's go through a full example where we create a database, create a few tables, and then list all tables in the database.
- Create a Database:
CREATE DATABASE company;
- Select the Database:
USE company;
- Create the Tables:
CREATE TABLE employees (
id INT PRIMARY KEY AUTO_INCREMENT,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email VARCHAR(100) UNIQUE,
hire_date DATE
);
CREATE TABLE departments (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) NOT NULL
);
CREATE TABLE projects (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
start_date DATE,
end_date DATE
);
- Show All Tables:
SHOW TABLES;
Output
| Tables_in_company |
|---|
| employees |
| departments |
| projects |
Important Considerations
- Database Selection: Ensure you have selected the correct database using the
USEstatement before runningSHOW TABLES. - Permissions: You need the appropriate permissions to view tables in the database. Typically, this requires at least read access to the database.
Conclusion
The SHOW TABLES statement is a simple but powerful command for listing all tables in a MySQL database. This chapter covered how to use SHOW TABLES to see what tables exist in your database, providing a quick way to verify table creation and manage your database structure.
My Top and Bestseller Udemy Courses. The sale is going on with a 70 - 80% discount. The discount coupon has been added to each course below:
Build REST APIs with Spring Boot 4, Spring Security 7, and JWT
![[NEW] Learn Apache Maven with IntelliJ IDEA and Java 25](https://img-c.udemycdn.com/course/750x422/6852721_b512_2.jpg "[NEW] Learn Apache Maven with IntelliJ IDEA and Java 25")
[NEW] Learn Apache Maven with IntelliJ IDEA and Java 25
ChatGPT + Generative AI + Prompt Engineering for Beginners
Spring 7 and Spring Boot 4 for Beginners (Includes 8 Projects)
Available in Udemy for Business
Building Real-Time REST APIs with Spring Boot - Blog App
Available in Udemy for Business
Building Microservices with Spring Boot and Spring Cloud
Available in Udemy for Business
Java Full-Stack Developer Course with Spring Boot and React JS
Available in Udemy for Business
Build 5 Spring Boot Projects with Java: Line-by-Line Coding
Testing Spring Boot Application with JUnit and Mockito
Available in Udemy for Business
Spring Boot Thymeleaf Real-Time Web Application - Blog App
Available in Udemy for Business
Master Spring Data JPA with Hibernate
Available in Udemy for Business
Spring Boot + Apache Kafka Course - The Practical Guide
Available in Udemy for Business
Comments
Post a Comment
Leave Comment