how to retrieve all the table names of any database server

Question

Using System.Data.OleDB;

how to retrieve all the table names of any database server
ex : oracle (scott/tiger) ?

I want to retrieve all the table names of (scott/tiger) using one combobox on the form. 
Pl. if anybody could suggest me how to do this in C#.NET ?

Answer 1

Using .Net: see OleDbConnection, GetOleDbSchemaTable method. Unfortunately, another connections has no such methods ...

Answer 2

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

Answer 3

See this article:

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