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

19 votes154 views6 answers
Laravel sql query
SQL
-1 vote150 views1 answer
Sql oracle take only last results
SQL
0 vote152 views1 answer
Implizite joins sql
SQL
0 vote172 views1 answer
Declaring variables in pl sql
SQL
0 vote166 views1 answer
Sql query to find duplicate email address
SQL
0 vote164 views1 answer
Oracle query to find schema you are working on
SQL
0 vote146 views1 answer
Mysql group rows with same value
SQL
0 vote176 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote172 views1 answer
Dataframe lambda elif
SQL
0 vote155 views1 answer
Alter precision
SQL