How to find ONLY system tables in MySQL database?
<p>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. </p>

<p>For example, by executing the below query </p>

<pre><code> SELECT table_name, table_type, engine, TABLE_COMMENT 
   FROM information_schema.tables 
   Where TABLE_SCHEMA = 'mysql' 
   order by engine desc; 
</code></pre>

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

<p>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 ...? </p>