Results 1 to 4 of 4

Thread: DB2 and schemas

  1. #1
    Join Date
    Apr 2011
    Posts
    38

    Unanswered: DB2 and schemas

    What is the command to change your schema in DB2? And what is the command to get a list of tables in a certain schema?

  2. #2
    Join Date
    Apr 2011
    Posts
    38
    Found the answer: list tables for schema schema-name

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by merik View Post
    what is the command to change your schema in db2?
    set current schema=
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Apr 2011
    Posts
    38
    Awesome. Thanks.

Posting Permissions

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