Re: [sqlite] Why "TRUNCATE TABLE" can't empty a table?

Use DROP TABLE students; That will permanently delete the table students. This is irreversible and cannot be undone. On Tue, Aug 14, 2012 at 4:06 AM, Dan Kennedy wrote: > On 08/14/2012 02:04 PM, daedae11 wrote: > >> Following is my program: >> rc = sqlite3_exec(db,

Re: [sqlite] Why "TRUNCATE TABLE" can't empty a table?

On 08/14/2012 02:04 PM, daedae11 wrote: Following is my program: rc = sqlite3_exec(db, "TRUNCATE TABLE students;", NULL, NULL, ); DELETE FROM students; ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Why "TRUNCATE TABLE" can't empty a table?

Following is my program: rc = sqlite3_exec(db, "TRUNCATE TABLE students;", NULL, NULL, ); but this sentence can success and return 1. Help~ ___ sqlite-users mailing list sqlite-users@sqlite.org