get table name not including view

[anwar5218]

how to get all table name in database not include "view" and Not using "like" pattern?

[Antaeus]

You can try to execute the following command with a TMyQuery object:

Code: Select all

SHOW TABLE STATUS FROM db_name

Value for the `Engine` field is an empty string for views. So you can perform local filtering by this field:

Code: Select all

MyQuery.Filter := 'Engine = ''''';