Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Exclamation Unanswered: view all tables in msde database

    Hi,

    I have a application that uses a MSDE database to store information. The application seems to hit into a database corruption problem. Now I would like to view all the datas and tables created in the database. How can I do that using OSQL ?? What are the commands to view all the tables in this database ? Or is there any other better applications to do the viewing ??
    Please advise. Thanx a lot !!


  2. #2
    Join Date
    Jan 2004
    Posts
    49

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    SP_HELP is the basic statement lists the complete objects in the database.
    Or even use SP_TABLES from OSQL to list the tables.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Apr 2004
    Posts
    2

    Talking Gentleman, Thank you very very much!

    Gentleman, Thank you very very much!

Posting Permissions

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