Devart Forums

Posted: **Thu 21 Dec 2006 11:22**

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

Posted: **Fri 22 Dec 2006 16:40**

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

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:

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

get table name not including view