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 vote229 views1 answer
Sqlite version check
SQL
0 vote208 views1 answer
Mysql group by derived column
SQL
2 votes201 views1 answer
Mysql sysdate - 1 day
SQL
2 votes293 views1 answer
Query to check cpu utilization in oracle database
SQL
7 votes208 views2 answers
Mysql check db size
SQL
3 votes198 views2 answers
Postgresql remove not null constraint
SQL
0 vote216 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote209 views1 answer
Porcentaje sql
SQL
12 votes260 views2 answers
Update column data type postgres
SQL
6 votes194 views1 answer
Oracle trigger after logon on database
SQL