Find my database

Hi,

I'm Writing a small wizard to lead users through connecting my client
to the database.

I've found some code that enumerates all available MS SQL Servers, and
another piece that lists all the databases on a specified server. I
was just wondering if there's a way to go a stage further and ensure
the database is actually the one I want them connecting to.

Is there a way with MS SQL to request a list the tables in the database?

(Expect me back here in a month asking if there's a way to
programatically deploy an SQL database *8)

Cheers,
Rik

.

Relevant Pages

  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)
  • Re: dbdebunk Quote of Week comment
    ... But SQL does not have a pointer data type or the ... More and more programmers who have absolutely no database training are ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: Running SQL script through VB
    ... I am connecting through a default username and my ... The error I am getting while running a script (generated by SQL server ... "A use database statement is not allowed in a procedure or trigger" ...
    (microsoft.public.dotnet.languages.vb)