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

1 vote151 views1 answer
Blazor option selected
C#
8 votes186 views6 answers
Donald trump
C#
0 vote190 views1 answer
7485438
C#
0 vote165 views1 answer
Get all classes that extend a class c#
C#
-1 vote123 views1 answer
Load Level Action for unity
C#
1 vote165 views1 answer
Find word in string array c#
C#
3 votes160 views1 answer
Unity get project file directory
C#
1 vote173 views2 answers
C# string verbatim
C#
0 vote219 views1 answer
The type or namespace name 'Notifications' does not exist in the namespace 'Unity' (are you missing an assembly reference?)
C#Unity
1 vote176 views1 answer
C# fontweight in code
C#