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 vote162 views1 answer
Query to insert image
SQL
0 vote207 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
1 vote155 views1 answer
Mysql select row with max value group by
SQL
12 votes196 views4 answers
How to check mysql version ubuntu
SQL
14 votes171 views2 answers
Sql cast
SQL
3 votes179 views1 answer
V$session not found in oracle
SQL
0 vote176 views1 answer
On sql table data exists
SQL
10 votes170 views1 answer
Dba_dependencies
SQL
0 vote198 views2 answers
Postgresql variable in query
SQL
0 vote210 views1 answer
How to compile a function in oracle
SQL