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 vote264 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote282 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote284 views1 answer
Sql avg group by
SQL
0 vote288 views1 answer
Select in select sql
SQL
0 vote300 views1 answer
What is top n result in sql
SQL
0 vote234 views1 answer
Check if due date is less than todays date sql
SQL
0 vote299 views1 answer
PSQL use LIKE with timestamps
SQL
4 votes297 views2 answers
Linq join
SQL
2 votes288 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote287 views1 answer
Function sum(text) does not exist postgres
SQL