Geek asks and answers

Show only user created tables in MySQL?

Is there an SQL command by which I can display only tables created by users and excluding those present by default in the MySQL database?

+3
source share
1 answer

Here about it:

select * from information_schema.tables 
where table_schema not in ('information_schema', 'mysql', 'performance_schema')

information_schemacontains meta information about your database. You can list all tables using information_schema.tables. If you exclude two meta-schemes information_schemaand mysql, you will get all user tables

+3
source

More articles:


All Articles