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 vote263 views1 answer
7485438
C#
0 vote323 views1 answer
C# WPF Timer
C#
1 vote253 views1 answer
Search the third word in string in c#
C#
0 vote262 views2 answers
How to find current country c#
C#
2 votes309 views1 answer
Unity right click on gameobject
C#Unity
-1 vote293 views3 answers
C# string with double quotes inside
C#
0 vote262 views1 answer
Polling data source c# using threads
C#
0 vote260 views1 answer
C# convert linq jValue to int
C#
2 votes278 views2 answers
Largest element in array in c#
C#
2 votes290 views1 answer
Change array size in unity
C#Unity