Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    2

    Unanswered: display/show tablename

    hi,
    anybody know if it is possible to display only the table names? I would like to run a query that display the table names....

    thanks

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Take a look at the sysobjects table in the sql books online. Here is an example of a query that will return user tables from a database:

    select * from sysobjects where xtype = 'U'

Posting Permissions

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