Results 1 to 4 of 4

Thread: Alter schema

  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Alter schema

    HI,
    in DB2 UDB, I have a database with name (sample), in this database, i have two schemas namely "sf", "sf123". in "sf" schema i have 10 tables. These tables i have to transfer to schema "sf123". I mean those 10 tables to be moved/copied to "sf123" schema.
    These two schemas are available in same database (sample).

    If any body have the idea. Please pass on your comments.


    Thanks
    Sudarshan

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Check out the RENAME TABLE/INDEX SQL command in the SQL Reference manual.

  3. #3
    Join Date
    Dec 2002
    Posts
    134
    Rename does not support moving across schemas (at least on 8.1 for win/*nix).
    If you do not want to move the data (export/load, db2look/db2move or something similar), you can probably create aliases.

    regards,
    dmitri

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Thanks chuzhoi. THe manual was not clear on the point and I did not try it.

Posting Permissions

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