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 vote288 views2 answers
How to update the multiple rows in sql
SQL
0 vote312 views1 answer
DATEDIFF minute postgres
SQL
2 votes300 views1 answer
Drop sequence
SQL
8 votes308 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
28 votes301 views6 answers
Mysql change user password
SQL
2 votes284 views1 answer
Create table with primary key
SQL
4 votes289 views1 answer
Id primary key auto generated
SQL
10 votes307 views1 answer
Oracle dba_dependencies
SQL
3 votes302 views1 answer
Set default today mysql
SQL
0 vote288 views1 answer
Difference between varchar and varchar2
SQL