List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 22 2000 9:20pm
Subject:Re: Creating a table with same structure than another
View as plain text  
In the last episode (Feb 22), Dax Mickelson said:
> Will create table foo select * from bar create the column structure
> AND copy over the data?  (i.e.  Could this be used to make a backup
> table?)

Yes, it'll copy the data over.  If all you want is the same field
definitions, use "create table foo select * from bar where 1=0".  If
you want the same indexes on the new table, you'll have to manually
create them.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Creating a table with same structure than anotherFran├žois Rossignol22 Feb
  • Re: Creating a table with same structure than anothersasha22 Feb
  • Re: Creating a table with same structure than anotherDax Mickelson22 Feb
    • caanot open shared object fileMaarten van Leunen22 Feb
      • Re: caanot open shared object filesinisa23 Feb
    • Re: Creating a table with same structure than anotherDan Nelson23 Feb
  • Re: Creating a table with same structure than anotherJames Lyon23 Feb
Re: Creating a table with same structure than anotherEd Carp23 Feb