How to find system tables in MySQL database ?
Hi,
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 ...?
Regards,
Nagaraju
Subject
Written By
Posted
How to find system tables in MySQL database ?
December 23, 2016 03:09AM
December 23, 2016 10:51AM
December 27, 2016 03:26AM
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.