create table new_table like old_table in database employee


-----Original Message-----
From: Joe Philip
[mailto:db2udbdba-ezmlmshield-x53898925.[Email address protected]
Sent: Tuesday, June 15, 2004 11:53 PM
To: LazyDBA Discussion
Subject: easiest way to create a backup a table in Db2 UDB


What is the easy way to create a copy of a table? In oracle, I used to do
this:
create table tab_copy as (select * from tab1);

I could not get it working for DB2 to create an exact copy of the table. Is
there a better way to do this?



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]

DB2 & UDB email list listserv db2-l LazyDBA home page