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 vote118 views1 answer
C# system.drawing.color to system.windows.media.color
C#
2 votes123 views1 answer
Bin/bash bad interpreter
C#
1 vote111 views1 answer
America
C#
0 vote125 views1 answer
How to convert int to char in c#
C#
5 votes116 views3 answers
C# exit foreach
C#
33 votes110 views4 answers
How to reload current scene unity
C#
0 vote164 views1 answer
Unity c# hooke's law suspension
C#Unity
1 vote112 views1 answer
Decimal to string c#
C#
0 vote127 views1 answer
Gridview column cell alignment form c#
C#
0 vote131 views1 answer
Wpf textbox insert text at caret position
C#