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 vote198 views1 answer
How to print sql query
SQL
10 votes214 views4 answers
Mysql one week ago
SQL
2 votes159 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote160 views1 answer
Get sum sqlite android
SQL
0 vote235 views1 answer
Mysql extract day from date leading zero
SQL
0 vote224 views1 answer
Updating database in sql
SQL
5 votes177 views3 answers
Oracle first day of last year
SQL
0 vote164 views1 answer
Mysql show category once count how many products
SQL
1 vote172 views1 answer
Get all db sizes in mysql server
SQL
0 vote178 views1 answer
Windows aggregate functions in postgresql
SQL