Delete table sqlite

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 vote228 views1 answer
Grouping by email domain mysql
SQL
0 vote225 views2 answers
Suse Linux restart MySQL
SQL
0 vote266 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote183 views1 answer
Mysql change default collation
SQL
1 vote186 views3 answers
What is union in sql
SQL
3 votes214 views5 answers
No module named 'MySQLdb'
SQL
-1 vote250 views4 answers
Full outer join in sql
SQL
0 vote147 views2 answers
Postgresql could not start server mac
SQL
1 vote200 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote178 views1 answer
Postgresql parse json array
SQL