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

0 vote352 views1 answer
Mysql update from n to 100
SQL
0 vote352 views1 answer
Dump multiple tables mysql
SQL
0 vote382 views2 answers
Create row number in sql
SQL
0 vote337 views1 answer
Get who is hired in january in sql
SQL
3 votes333 views1 answer
Oracle user quota unlimited
SQL
3 votes380 views2 answers
Mysql update row
SQL
0 vote363 views1 answer
Every Derived yable must have its own alias
SQL
2 votes383 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote370 views2 answers
How to add CHECK constraint to a column in postgres
SQL
3 votes329 views2 answers
Oracle sql truncate table
SQL