Retrieve the List of Table Names

seenu01 · #1 (**permalink**) 02-17-2006, 01:40 AM

Hi,

How can I retrieve the list of table names from backend database ODBC connection, Using C#?

Any Solution!
Much Thanks...

sanereddy · #2 (**permalink**) 02-17-2006, 07:20 AM

Hello Seenu, What is the databse you are using..? . Thanks,

seenu01 · #3 (**permalink**) 02-17-2006, 12:22 PM

Hi Reddy

I plan to use MS Access for time being, Will that be suitable. Which one do you suggest. My main objective should be fulfilled, i.e., retriving table names...

Thanks

techguru · #4 (**permalink**) 02-17-2006, 02:09 PM

try this ...

select name from msysobjects where type=1 using ado or any other data access..