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

6 votes294 views2 answers
Drop foreign key
SQL
0 vote308 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote288 views1 answer
Mssql check if date is greater than today
SQL
15 votes279 views2 answers
How to drop database name in postgresql
SQL
0 vote297 views1 answer
Formatting code with SQL Developer
SQL
0 vote282 views1 answer
Mysql regex exact match
SQL
35 votes345 views5 answers
Sql alter column
SQL
0 vote298 views1 answer
Mysql select statement after index
SQL
3 votes275 views1 answer
Index using in query plsql
SQL
1 vote285 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL