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

9 votes356 views3 answers
Find all tables with column name
SQL
0 vote329 views1 answer
Sql server remove enter from string
SQL
1 vote337 views1 answer
Join first name and last name sql
SQL
0 vote344 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
10 votes320 views2 answers
Sql rtrim
SQL
0 vote303 views1 answer
Parsing float to int in mysql
SQL
0 vote305 views1 answer
Sql comparison operators
SQL
0 vote352 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote335 views2 answers
Nosqlbooster query other collection
SQL
1 vote375 views1 answer
Delete dublicate rows sql
SQL