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

1 vote205 views3 answers
Mysql on delete set null
SQL
1 vote200 views1 answer
Isnull sql server
SQL
0 vote175 views1 answer
Calculate date and convert to yearsmysql
SQL
3 votes175 views1 answer
Start mysql server linux terminal
SQL
5 votes237 views2 answers
Mysql where in array
SQL
1 vote183 views1 answer
Generate random data postgresql
SQL
1 vote179 views1 answer
Pv mysql import
SQL
1 vote193 views1 answer
Count mysql server db tables
SQL
0 vote201 views1 answer
Postgresql regular expression special characters
SQL
1 vote194 views1 answer
Best configuration for display table in sqlplus
SQL