Results 1 to 3 of 3

Thread: List of tables

  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Unanswered: List of tables

    Hi,

    Is there any command to find all the tables(including system tables) in SQLserver(I do not want to use enterprise manager).

    Regards,

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: List of tables

    Originally posted by sursujmad
    Hi,

    Is there any command to find all the tables(including system tables) in SQLserver(I do not want to use enterprise manager).

    Regards,
    You can use a sql request like this

    select * from sysobjects where type = 's' or type = 'u'
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    --Try
    exec sp_tables
    select user_name(uid)+'.'+name from sysobjects where xtype in ('U','S')
    select * from information_schema.tables

Posting Permissions

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