CODEWITHSUNDEEP
mysql
svk
svk

Reputation: 4553

Get SQL tables only not views?

SHOW TABLES

This lists the view also.

But I don't want the view in the list.

How can I write the Query and get that?

I am using Mysql 5 and MyIsAm is my DB engine.

Upvotes: 4

Views: 3636

Answers (1)

MikeTheReader
MikeTheReader

Reputation: 4190

This should work:

SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE';

If you need to filter it based on schema, then you can add:

AND TABLE_SCHEMA = 'schema_name'

Take a look at the information_schema.tables table and you'll see other ways to filter the list.

Upvotes: 7

Related Questions