How to find system tables in MySQL database ?
Posted by: nagaraju manchala
Date: December 23, 2016 03:09AM


I am trying to find the list of MySQL's system tables (or internal tables).
The database "mysql" contains both its system tables (internal or proprietary to MySQL database) and user created tables.

For example, by executing the below query
SELECT table_name, table_type, engine, TABLE_COMMENT
FROM information_schema.tables
Where TABLE_SCHEMA = 'mysql'
order by engine desc;

we get all tables' type as 'BASE TABLE' only. These entries include my user table also (for example, CREATE TABLE mysql.tst1 (i INT) ENGINE = MYISAM;)

Could you please let me know how can we differentiate between internal(or system) tables AND user created tables? Do we have any query or system objects like stored procedure ....etc ...?


Options: ReplyQuote

Written By
How to find system tables in MySQL database ?
December 23, 2016 03:09AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.