Hi,
I want to select my database at run time(oracle or sql or access or...)
But to get description of database objects what I have to do.
Is there any method similar to DESC in oracle which I can use with all the Databases.
thanks
gana

Did you try using ADOX (should be able to work with any DB, as long as your connection string is right).

http://www.able-consulting.com/ADO_Conn.htm

maybe something like this?:
http://www.gab2001uk.com/visualbasic.../adoschema.htm

HTH

Hi
Thanks for reply. I understood How to get the description from the table and veiw. But how to get the description for the Stored procedures?
will the same thing works for that also.
regards
gana

I'm not sure if you can do that from SQL/Oracle, but I know you can from Access (Using DAO, I think).

HTH