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 vote224 views1 answer
C# datetime dd/mm/yyy hh:mm:ss
C#
2 votes181 views1 answer
How to cjeck if a string has a word c#
C#
10 votes261 views2 answers
How to set a color of text in unity 2020 script
C#Unity
0 vote191 views1 answer
.net disable show exception
C#
1 vote231 views1 answer
C# datagridview search filter
C#
2 votes247 views1 answer
Unity public static variable
C#Unity
1 vote169 views1 answer
Unity time.deltatime timescale 0
C#
0 vote180 views1 answer
Membership get user id
C#
0 vote203 views1 answer
Asp.net core api Self referencing loop detected for property
C#
1 vote177 views1 answer
C# empty char
C#