468,257 Members | 1,412 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

Change schema name

Greetings,

How do you change the schema name of a table?

db2 rename table admin.employees to emp.employees

returns SQL0108N

db2 +c set current schema emp

db2 +c rename table admin.employees to employees

returns SQL0601N

Thanks for any input.
Nov 12 '05 #1
1 12719
y can try to export the table and import with another schema.
im********@yahoo.com (Iman) wrote in message news:<38**************************@posting.google. com>...
Greetings,

How do you change the schema name of a table?

db2 rename table admin.employees to emp.employees

returns SQL0108N

db2 +c set current schema emp

db2 +c rename table admin.employees to employees

returns SQL0601N

Thanks for any input.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Gordon Dickens | last post: by
4 posts views Thread by Iain A. Mcleod | last post: by
2 posts views Thread by Daniel Lidström | last post: by
1 post views Thread by billa1972 | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.