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 vote114 views1 answer
Can you use unity for ftee
C#
2 votes113 views1 answer
C# enum default
C#
0 vote172 views1 answer
Qcombobox delegate text filter
C#
0 vote128 views1 answer
Declare string array c# without size
C#
0 vote121 views1 answer
C# merge two lists as queryable
C#
0 vote111 views1 answer
Unity topdown 2d look
C#
5 votes98 views2 answers
How to exit application c# console
C#
4 votes107 views1 answer
Get out of foreach statement c#
C#
0 vote143 views3 answers
Entity save example in c# model first
C#
0 vote109 views1 answer
Check if list contains any empty element in c#
C#