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 vote110 views1 answer
Sqldf change user
SQL
0 vote120 views1 answer
Sql create table with datetime automatically
SQL
3 votes115 views4 answers
Ubuntu stop mysql
SQL
1 vote118 views1 answer
What is in condition in sql
SQL
2 votes133 views2 answers
Mysql on duplicate key update get value from values
SQL
1 vote126 views1 answer
Myql find duplicates
SQL
0 vote118 views1 answer
SAP Return
SQL
0 vote142 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote111 views1 answer
Where case insensitive like mysql
SQL
1 vote124 views1 answer
Error code 1292 mysql workbench
SQL