Re: Freeware for Sql server??

de Bjorn Abelli 04/17/2006 11:07

"Annie" wrote...

> 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.
>
> Or any other options?

I don't remember what options Enterprise Manager has, but if you have the
possibility to write ad hoc queries to the SQL Server there, or in some
other tool, you can use a simple SQL statement like this:

SELECT * FROM Information_Schema.Tables
where Table_Type = 'BASE TABLE'
and Table_name LIKE '%searchcriteria%'

...where you change the search criteria as you like it.

'%' is the wildcard.

If I had just a little more spare time I would write one for you... ;-)

// Bjorn A
http://www.abelli.se/software/