Retrieve the List of Table Names

[seenu01]

Hi,

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

Any Solution!
Much Thanks...

[sanereddy]

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

[seenu01]

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]

try this ...

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