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

24 votes384 views6 answers
Sql change table name
SQL
0 vote343 views1 answer
Sql server remove enter from string
SQL
0 vote350 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
2 votes358 views3 answers
Postgres create view
SQL
0 vote332 views1 answer
Mysql grant access to one database
SQL
0 vote393 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
5 votes366 views1 answer
Purge undo tablespace usage
SQL
0 vote348 views2 answers
Psql commande \gset
SQL
0 vote342 views1 answer
Sql show all users
SQL
0 vote340 views1 answer
Less than date query sqlachemy
SQL