Re: Freeware for Sql server??

de Man-wai Chang 04/17/2006 10:29

Annie wrote:
> hello guys,
>
> is there any freeware to enable to search for table names in Enterprise
> Manager.
> As the tables are getting too long its very hard to find a table to work
> with eg 850 tables ;-)
>
> Is there any freeware / addin to sql server 2000 where enable to search
> through the tables
> based on specific criteria / wild card.

You should select * from INFORMATION_SCHEMA.tables in SQL Server.

--
.~. Might, Courage, Vision. SINCERITY. http://www.linux-sxs.org
/ v Simplicity is Beauty! May the Force and Farce be with you!
/( _ ) (Ubuntu 5.10) Linux 2.6.16.5
^ ^ 16:29:03 up 1 day 6:25 load average: 1.31 1.07 1.02
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk