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

62 votes501 views8 answers
Mysql add column
SQL
3 votes234 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
12 votes196 views1 answer
Script to add new column in table sql
SQL
0 vote191 views1 answer
Mysql record group by created date count
SQL
9 votes237 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
2 votes372 views1 answer
Set auto increment from 1
SQL
-1 vote251 views4 answers
Postgres between dates
SQL
4 votes186 views3 answers
Order by value mysql
SQL
-1 vote262 views1 answer
Sql show custom constraints
SQL
0 vote197 views1 answer
Mysql update privileges
SQL