how to retrieve all the table names of any database server

Hi

If you are looking 4 SQL Server 2000/2005 query then
you can fetch all of the tables from the current database by executing the mentioned query

select * from sysobjects where type='u'

This table is having all information reg the current database.

Hope you got your solution

rahu_ketu

See this article:

http://www.csharpcorner.com/UploadFile/Ashish1/oracleTables11082005154730PM/oracleTables.aspx?ArticleID=3d9d8662-9e53-45c4-ad13-df59ee5d0603