Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    9

    Unanswered: Enumerate tables given a database?

    Hi

    To enumerate database:

    sp_helpdb

    now, how do I enumerate tables given a database?

    Thanks!

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    sp_help
    to display all objects and datatypes in the current database.
    sp_help [objname]
    to display information about a specified database object
    or
    select name, user_name(uid) as owner from sysobjects where type='U'

  3. #3
    Join Date
    Dec 2007
    Location
    Chennai,India
    Posts
    12
    sp_tables will list the tables and views in your current database

Posting Permissions

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