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 vote302 views1 answer
Mariadb list tables
SQL
0 vote348 views1 answer
Sql shell psql cannot enter password
SQL
0 vote316 views1 answer
Postgresql subquery
SQL
-1 vote330 views3 answers
Update mongodb version ubuntu
SQL
0 vote367 views1 answer
Local pg_sql to heroku pg_sql
SQL
12 votes321 views3 answers
Duplicate a column in sql
SQL
1 vote345 views1 answer
Md5 encryption for existing records
SQL
0 vote369 views1 answer
How to check database engine in mysql
SQL
3 votes362 views1 answer
Two select sql
SQL
0 vote353 views1 answer
Show the colums of table sql
SQL