How to Remove all table rows from Sq Lite database table?

Question

I want to remove all rows that i entered from my SQLite database table.I will need any new example.

no, you don't need any examples, you need to learn the **basisc** of SQL — pskink, Sep 14 '15 at 07:43
but compare sql to sqlite, is different ..I will need any new example query to remove all rows that i entered from my SQLite database table. — Vishnu palanivel m, Sep 14 '15 at 07:46
no, you will not `"need any new example query"`, you have to learn it on your own, nobody will do your homework... — pskink, Sep 14 '15 at 07:50

score 0 · Answer 1 · answered Sep 14 '15 at 07:50

0

delete from TABLE_NAME to delete all data from table

if you want to see sample then this is best link -

http://javatechig.com/android/android-sqlite-database-tutorial

answered Sep 14 '15 at 07:50

Ashish Agrawal

1,977
2
18
32

Thanks you sir this link very useful for me.. – Vishnu palanivel m Sep 14 '15 at 08:55
if this answer is useful for you then please accept it.thanks – Ashish Agrawal Sep 14 '15 at 10:18

score 0 · Accepted Answer · answered Sep 14 '15 at 07:51

0

Unfortunately, we do not have TRUNCATE TABLE command in SQLite but you can use SQLite DELETE command to delete complete data from an existing table, though it is recommended to use DROP TABLE command to drop complete table and re-create it once again.

The basic syntax of DELETE command is as follows:

sqlite> DELETE FROM table_name;

The basic syntax of DROP TABLE is as follows:

sqlite> DROP TABLE table_name;

Taken from here

answered Sep 14 '15 at 07:51

Bhargav

8,118
6
40
63

1

Thanks you sir this link very useful for me.. – Vishnu palanivel m Sep 14 '15 at 08:54

How to Remove all table rows from Sq Lite database table?

2 Answers2