Database "Insert Into" Help Needed

[Smee]

First Post.
Is there a sql lite equivalaent to the expression
"SELECT TableName.* INTO NewTable FROM TableName". Or is there a work around such as renaming a table?

Can any suggest any simplistic code?

Many thanks

 

[RB Smissaert]

Have a look here:

SQLite Query Language: ALTER TABLE

RBS

 

[Smee]

Thanks,

That code works ok

Smee