Hi All,

I need to be able to retrieve and parse all field names of an SQL database table via C#.

So far I've been able to do it using oledb AND have been able to get the schema using a reader and executing "SELECT * FROM SOMETHABLENAME" and then using rdrReader.GetSchemaTable(). But my problem with that is that I don't want to use a predetermined table name. I need to query tables dynamically and then query field names dynamically too.

Any suggestions and help is greatly appreciated.

Thanks in advance,
Khemal

Apparently oledbSchemaGuid is what you should use for this.
Hope these places help.

http://www.dotnet247.com/247referenc...29/146507.aspx - at bottom of page gives example

This will show you all the methods:
http://msdn.microsoft.com/library/de...mberstopic.asp

Have fun.

Cool! Thanks. Will try it out.