Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    15

    Thumbs up Unanswered: list of tables in sybase

    how to see the list of tables in sybase? Can any one post the solution.....

  2. #2
    Join Date
    Jun 2011
    Posts
    28
    Hello

    What you need its

    Code:
    SELECT name
    FROM sysobjects
    WHERE 
    type = 'U'
    Regards

  3. #3
    Join Date
    Jun 2009
    Posts
    25
    If you want to check user-defined tables then you can use the above query or Suppose If you want to know about system tables then by slight modification of the above query by changing the type to 'S' we can know the list of system tables in sybase.

    SELECT name
    FROM sysobjects
    WHERE
    type = 'S'

Posting Permissions

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