How to show specific tables

jackps · January 14th, 2004, 02:48 AM

Dear all
I had a lot of tables created in my sql database, now i want to show all the table which contain the word "Transaction" in table's name, is there any query can do this?

Thx alot

Jack:)

Jeff Mason · January 14th, 2004, 10:40 AM

You can use the INFORMATION_SCHEMA.TABLES system view:

Code:

SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%Transaction%';

This of course begs the question of why you would have so many tables that you need a query to keep track of them. That many tables is a red flag concerning your database design...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com