Re: How do I get a list of available tables?

From: Adam Machanic (amachanic_at_air-worldwide.nospamallowed.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 11:09:10 -0500

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%text%'

"James C" <jchin@vansco.ca> wrote in message
news:8504E7E4-3584-4D62-9603-1A7A3388169A@microsoft.com...
> How do I get a list of tables that contain specific text in the name of
the table? Is this even possible?