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

10 votes186 views6 answers
Between sql
SQL
0 vote169 views1 answer
Database xml sql
SQL
0 vote239 views1 answer
Opensuse start MySQL
SQL
0 vote180 views1 answer
Clone table structure mysql
SQL
6 votes214 views2 answers
Mysql check auto increment value
SQL
0 vote218 views1 answer
Sql cheetsheet
SQL
0 vote194 views1 answer
Mysql get only the field names in a table
SQL
1 vote174 views1 answer
Mysql get last insert id
SQL
3 votes168 views1 answer
Postgres kill running query
SQL
0 vote173 views1 answer
Mysql sql.gz
SQL