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

7 votes283 views4 answers
Index in mysql
SQL
0 vote270 views1 answer
Postgres sequence name
SQL
2 votes254 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
39 votes313 views4 answers
Select duplicates in sql
SQL
0 vote289 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote255 views1 answer
Ksql quickstart docker
SQL
1 vote262 views1 answer
Mysql current time
SQL
4 votes256 views2 answers
REST API
SQL
1 vote257 views1 answer
Oracle sql average
SQL
0 vote267 views1 answer
Less than date query sqlachemy
SQL