SQLite Drop Table

How to delete table sqlite

# SQLite->
DROP TABLE table_name

Sqlite drop table

DROP TABLE IF EXISTS table_name

Delete table sqlite

import sqlite3
db = "./db.sqlite3"
conn = sqlite3.connect(db)
conn.execute("DROP TABLE paintshop_category" )
conn.commit()
conn.close()
print('success')

SQLite Drop Table

cmd.CommandText = "DROP TABLE IF EXISTS cars";
cmd.ExecuteNonQuery();

Source: zetcode.com

Similar codes

0 vote178 views1 answer
Dictionary all key where value c#
C#
0 vote173 views2 answers
Linear search algorithm c#
C#
0 vote192 views1 answer
C# excel fix first row
C#
1 vote182 views1 answer
Canty obituary schenectady ny
C#
4 votes179 views1 answer
How to stop window from terminating c# visual studio
C#
0 vote174 views1 answer
Ubuntu: how zoom everything
C#
-1 vote189 views4 answers
How to exit winforms application and shutdown pc in c#
C#
1 vote222 views1 answer
How to create empty ui object unity
C#Unity
0 vote211 views1 answer
Générer un nombre aléatoire en c#
C#
0 vote165 views1 answer
Change text size unity
C#