Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    10

    Unanswered: How to change the schema name for a table?

    Hello,

    I have several questions :

    1. How to change the schema name of all the tables in a database without using db2move?

    2. How to change the table owner for a table?

    3. If db2move should be used, can it support data types such as BLOB and identity?


    Thanks a lot.

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Some options

    I don't think you can change the qualifier for
    a table. You can create a new table like the old
    one with another qualifier. i.e.

    create table <newschema>.<tablename> like
    <oldschema>.<tablename>

    And erase the original one.

    The owner(creator) of a table is recorded as the qualifier
    at creation time, in sysibm.systables.
    You can specify a creator by explicitly qualifying the table,
    but I don't think you can change it afterwards

    BOW
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

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