Freeware for Sql server??

[Annie]

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.

Or any other options?

TIA

 

[Man-wai Chang]

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

 

[Bjorn Abelli]

...

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/

 

[Staff]

Annie ha scritto:

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.

Or any other options?

TIA

http://sqleonardo.altervista.org