dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Microsoft Windows 2000 SQL

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    Microsoft Windows 2000 SQL

    [Originally posted by Marcus]

    Hi,

    I am new to My SQL, may I know is there a way to know all the table name in the database stored in SQL server?? I has the password for the SQL server.

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Microsoft Windows 2000 SQL

    [Originally posted by m.posseth@work]

    are we talking about

    1. SQL server on a win 2000 machine ( maybe even the superieur SQL 2000 version ??? also known as Oracle killer ;-) )

    in this case you can retrieve this pretty easy with sqldmo


    or 2 .

    My SQL the opensource project˙ ( wich i don`t˙ know anything about so sorry )


    :-)



  3. #3
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Microsoft Windows 2000 SQL

    [Originally posted by Jim]

    execute sp_help in which ever db you want to get a list of

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center