Alter schema

sudarshan · #1 (**permalink**) 10-30-03, 05:32

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

Marcus_A · #2 (**permalink**) 10-30-03, 08:27

Check out the RENAME TABLE/INDEX SQL command in the SQL Reference manual.

chuzhoi · #3 (**permalink**) 10-30-03, 18:10

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

Marcus_A · #4 (**permalink**) 10-30-03, 22:39

Thanks chuzhoi. THe manual was not clear on the point and I did not try it.

Internet Services

Web Development

Digital Marketing

Consumer Tech