SQL All Tables

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

SQL All Tables

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)

Tutorials

  1. MySQL Create Table
  2. Mysql Add Column Default Value
  3. Mysql Add Column Number
  4. SQL Add Column Int
  5. SQL Add Column Position
  6. MySQL PHP Query delete
  7. Mysql Table Describe
  8. Mysql PHP Select
  9. MySQL PHP Search
  10. Mysql Table
  11. MySQL PHP Insert
  12. PHP SQL Search
  13. PHP SQL Insert
  14. PHP SQL Table
  15. PHP SQL Insert Statement
  16. PHP SQL Rows
  17. PHP SQL Fetch
  18. PHP SQL Select
  19. Mysql PHP Where
  20. PHP SQL Insertion
  21. SQL All Column Names
  22. SQL All Tables
  23. MySQL Add Column