Create a copy of an Oracle table without copying the data? By Shadab Mohammad • Dec 3, 2012 • 1 comment Do a "create table" as command without selecting any rows create table abc_new as select * from abc where 1=0; Share this: Share on X (Opens in new window) X Share on LinkedIn (Opens in new window) LinkedIn Share on Facebook (Opens in new window) Facebook Share on Tumblr (Opens in new window) Tumblr Share on WhatsApp (Opens in new window) WhatsApp Category: Database • SQL Tags: copy • no data • oracle • table • Tables • without data
Reblogged this on ???? ??????? and commented: Nice and simple idea to create a table from another table without copying any values to the new table. Reply
One comment
Reblogged this on ???? ??????? and commented:
Nice and simple idea to create a table from another table without copying any values to the new table.