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 ?

Andrzej Wegierski · Answer

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

Rahul Goel · Answer

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

Ashish Singhal · Answer

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