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 vote337 views1 answer
C# mail retrieve library
C#
0 vote329 views1 answer
Erewt
C#
0 vote299 views1 answer
C# xmldocument from file
C#
0 vote318 views1 answer
World space constant size
C#
8 votes305 views1 answer
Unity mouse lock
C#
0 vote325 views1 answer
Ascii art american flag
C#
7 votes404 views2 answers
Unity move character
C#Unity
9 votes329 views1 answer
You have the following c# code. stringbuilder sb = new stringbuilder(really long string); the really long string variable is a string in which a very long string is stored.
C#
0 vote344 views1 answer
Skrivetænking
C#
1 vote372 views1 answer
C# unity change key input in inspector
C#Unity