Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Unanswered: what is equivalent to desc

    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

  2. #2
    Join Date
    Jul 2003
    Posts
    21
    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

  3. #3
    Join Date
    Sep 2003
    Posts
    3
    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

  4. #4
    Join Date
    Jul 2003
    Posts
    21
    Originally posted by gana
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •