SQL All Tables

SQL All Tables is used to show all the tables in database.

Understand with Example

The Tutorial illustrate an example from 'SQL All Tables'. To understand and grasp the example we use query show tables that is used is show the tables in database 'komal'.

show tables : This is used to show the list of tables in database.

Query

mysql> show tables;
+-----------------+
| Tables_in_komal |
+-----------------+
| emp             |
| lib             |
| stu             |
| stu1            |
+-----------------+
4 rows in set (0.00 sec)

Related Tags for SQL All Tables:

More Tutorials from this section

• MySQL Add Column
• Mysql Table
• MySQL Create Table
• MySQL PHP Insert
• MySQL PHP Query delete
• MySQL PHP Search
• Mysql PHP Select
• Mysql PHP Where
• PHP SQL Fetch
• PHP SQL Insert Statement
• PHP SQL Insert
• PHP SQL Insertion
• Mysql Add Column Default Value
• Mysql Add Column Number
• SQL Add Column Int
• SQL Add Column Position
• SQL All Column Names
• SQL All Tables
• PHP SQL Rows
• PHP SQL Search

Ask Questions?    Discuss: SQL All Tables  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):