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

11 votes160 views4 answers
Query DISTINCT
SQL
0 vote227 views1 answer
Postgres rename database
SQL
0 vote175 views1 answer
T sql less than date
SQL
0 vote175 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote242 views1 answer
Oracle calculate statistics on partition
SQL
0 vote178 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote185 views1 answer
Utiliser sql ligne de commande
SQL
0 vote182 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote178 views1 answer
Postgresql certain first 4 characters in string
SQL
11 votes177 views2 answers
How to import mysql database command line
SQL