know tables of database

Results 1 to 4 of 4

Thread: know tables of database

  1. #1
    yann Guest

    Default know tables of database

    hi,<BR>I want to know all the tables of a database, after the connection.Is-it possible?<BR>Thanks for your help

  2. #2
    Tim Snyder Guest

    Default RE: know tables of database

    select name from sysobjects where type = &#039;U&#039; order by name",&#060;database&#062;

  3. #3
    Join Date
    Dec 1969

    Default RE: know tables of database

    Try this (pubs is a database in sql server, substitute with your own database name),<BR><BR><BR>Option 1 (user tables form a specific database):<BR>set rs = cn.OpenSchema(adSchemaTables,array("pubs","dbo",em pty,"table"))<BR><BR>Option 2 (all tables in all databases):<BR>set rs = cn.OpenSchema(adSchemaTables)<BR><BR>(remember to include<BR><BR>Here is the complete reference:<BR><BR>

  4. #4
    Rhino Guest

    Default Read this

Posting Permissions

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