field types are retained but indexes and triggers won't be copied On 4/14/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "Dennis Volodomanov" <[EMAIL PROTECTED]> writes: > > > So, "CREATE TABLE AS" will basically duplicate the table that I have (if > > I say for example, "CREATE TABLE AS myNewTable AS SELECT * FROM > > myOldTable")? Sounds good if that's true :-) > > You have one too many "AS" in your example. (No "AS" between CREATE TABLE and > the table name. Try it this way: > > CREATE TABLE myNewTable AS SELECT * FROM myOldTable; > > In sqlite 2.8.* you lose the field types (which were just comments in the 2.8 > series anyway). I suspect that in 3.0.* the field types are retained, but I > haven't tested it. You can verify with something like this: > > % sqlite :memory: > SQLite version 2.8.16 > Enter ".help" for instructions > sqlite> create table x (i integer); > sqlite> create table y as select * from x; > sqlite> .dump > BEGIN TRANSACTION; > create table x (i integer); > CREATE TABLE y(i); > COMMIT; > sqlite> > > Derrell >
-- Cory Nelson http://www.int64.org