> Is there a quick way to do that?

DROP TABLE table1;
ALTER TABLE table2 RENAME TO table1;

And doesn't matter how many rows and columns have each of the tables.

Hope I've understood your question correctly.
Pavel

On Thu, Oct 15, 2009 at 10:51 AM, Kavita Raghunathan
<kavita.raghunat...@skyfiber.com> wrote:
> Hi,
>
> Is there a way to use the sqlite wrappers to "replace" or delete a table 
> completely ?
> (without looping through and deleting each row and column)
> The number of columns and rows of the new table is identical to the number
> of columns and rows of the old table being replaced. Is there a quick way
> to do that?
>
> Thanks,
> Kavita
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to