List Tables In Database

Results 1 to 2 of 2

Thread: List Tables In Database

  1. #1
    Kevin Guest

    Default List Tables In Database

    I am trying to find the code to list all the tables in my database. I know I&#039ve seen it before but I can&#039t find it now that I need it. Can someone advise how to do this. Thanks in advance.

  2. #2
    karl Guest

    Default RE: List Tables In Database

    If you have access to Enterprise manager or SQL Query Analyser, simply execute:<BR><BR>sp_help<BR><BR><BR><BR>and look for "user table" (I think) under the "Object Type" column (I think)<BR><BR>karl<BR><BR>

Posting Permissions

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