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

0 vote314 views1 answer
Oracle sql drop table
SQL
0 vote298 views1 answer
Change data type in mysql
SQL
0 vote323 views1 answer
Datetime postgres typeorm
SQL
50 votes450 views6 answers
Sql count duplicate rows
SQL
1 vote325 views1 answer
SQL Integer devision
SQL
0 vote353 views2 answers
Impala rename column name
SQL
5 votes369 views1 answer
Mysql where one year ago
SQL
0 vote309 views1 answer
How to put is null in where in clause
SQL
6 votes340 views4 answers
Mysql group by date
SQL
0 vote341 views1 answer
Command to give readonly access to a postgres sql user
SQL