Entry

Database: Language: SQL: MySql: Table: Operation: View: How to view all tables in a database?

Apr 4th, 2005 09:30
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 04 April 2005 - 11:40 pm ----------------------

Database: Language: SQL: MySql: Table: Operation: View: How to view 
all tables in a database?

---

Use the commands

 use <your database name>

 show tables

---
---

e.g.

--- cut here: begin --------------------------------------------------

mysql> use test1;

Database changed

mysql> show tables;

+-----------------+
| Tables_in_test1 |
+-----------------+
| dddtablename    |
| table1          |
| table2          |
| table3          |
| table4          |
| table5          |
| tablename       |
| tablestudy      |
+-----------------+

8 rows in set (0.00 sec)

--- cut here: end ----------------------------------------------------

---
---

Internet: see also:

---

Table: Language: SQL: Overview: Can you give an overview of links 
about SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54

----------------------------------------------------------------------