table names collection in SQL Server 2000

[Davey]

Have a look at the INFORMATION_SCHEMA.* views,

e.g.

select * from information_schema.tables