List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 23 2000 4:12am
Subject:Re: copy table structure
View as plain text  
In the last episode (Sep 22), Balazs Wellisch said:
> Can anyone tell me how to copy a table structure? Not the data but the
> structure itself. I'm sure it's a function of CREATE TABLE somehow, but
> what's the exact syntax? I couldn't find it in the documentation.

Try something like "create table newtable select * from oldtable where
1=0".  You'll have to build the indexes yourself.

-- 
	Dan Nelson
	dnelson@stripped
Thread
copy table structureBalazs Wellisch23 Sep
  • Re: copy table structureDan Nelson23 Sep
    • RE: copy table structureRobert Goff23 Sep
  • Re: copy table structureDavid Tod Sigafoos23 Sep