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 vote221 views1 answer
Restart animation unity
C#
-1 vote249 views1 answer
C# recursion formula for the factorial
C#
1 vote228 views1 answer
C# how to simulate mouse click
C#
1 vote231 views1 answer
C# measure execution time
C#
10 votes238 views3 answers
Get percentage c#
C#
0 vote219 views2 answers
How to convert list of string to single string in c#
C#
0 vote194 views1 answer
Infinit range loop c#
C#
0 vote235 views1 answer
Detect mouse in bottom of screen + unity
C#
0 vote216 views1 answer
Set current date to textbox in asp.net
C#
2 votes243 views1 answer
Net.core "a path base can only be configured using iapplicationbuilder.usepathbase()"
C#