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

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


    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

    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

    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

    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