- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
How can we get only the name having no other details about the tables in MySQL database?
With the help of SHOW TABLES command, we can get only the name having no other information about the tables. For example, we can see the list of tables in a database named tutorial as follows −
mysql> show tables; +--------------------+ | Tables_in_tutorial | +--------------------+ | student | +--------------------+ 1 row in set (0.00 sec)
- Related Articles
- How can we use INFORMATION_SCHEMA to get the details about triggers in a particular database?
- How can we get the list of tables in a particular database from MySQL Server command line?
- While connecting to one MySQL database, how can I see the list of tables of other MySQL database?
- How can we see only name and types of the stored routines in a particular MySQL database?
- How can we check the character set of all the tables in a particular MySQL database?
- Get all the tables from a MySQL database having a specific column, let’s say xyz?
- How to get the list of tables in default MySQL database?
- How can we get more details about columns of an existing table than return by MySQL SHOW COLUMNS statement?
- How can we see MySQL temporary tables in the list of tables?
- How can we analyze the tables of a particular database from MySQL Server command line?
- How can I check the tables of databases other than current database?
- How to get the size of the tables of a MySQL database?
- How can we see only the list of stored procedures in a particular MySQL database?
- How can we see only the list of stored functions in a particular MySQL database?
- How can we write PHP script to get the list of MySQL database?
Advertisements