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

2 votes423 views1 answer
Unity right click on gameobject
C#Unity
2 votes352 views1 answer
Format float to time c#
C#
6 votes300 views1 answer
Movement slowly towards target unity
C#
8 votes420 views1 answer
Point to mouse 2D Unity
C#Unity
10 votes347 views4 answers
C# round double
C#
1 vote387 views1 answer
Xamarin forms open new page on button click
C#
31 votes365 views4 answers
Unity check if space pressed
C#Unity
0 vote329 views1 answer
Linq query languages
C#
3 votes331 views2 answers
Define a vector c#
C#
13 votes352 views3 answers
C# list get last element
C#