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
C# multiple exceptions same handler
C#
10 votes98 views2 answers
C# unity get name of object
C#
0 vote102 views1 answer
Call a .NET assembly from C or C++
C#
0 vote104 views1 answer
EF will not create columns RULE
C#
0 vote109 views1 answer
Exception handling in c# web api
C#
0 vote97 views1 answer
C# CheckwhethertheStringisapalindromeornot.
C#
3 votes105 views1 answer
Add dependency injection .net core console app
C#
12 votes109 views2 answers
Messagebox.show c# error
C#
0 vote173 views1 answer
How to learn c# fast to learn unity
C#Unity
0 vote101 views1 answer
Pcamera
C#