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 vote319 views1 answer
C# read binary file
C#
0 vote281 views1 answer
Degree between two points latitude longitude c#
C#
18 votes323 views2 answers
Unity remove all child
C#Unity
2 votes280 views2 answers
Making a list of chars in c#
C#
0 vote287 views1 answer
How to preset an array c#
C#
2 votes325 views1 answer
Hide console window c#
C#
2 votes290 views1 answer
Photon how to destroy object
C#
0 vote304 views1 answer
Embed video to exe file with c#
C#
0 vote292 views1 answer
Pyqt qtableview get selected row data
C#
0 vote321 views1 answer
What does focusbale do in listview WPF
C#