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 vote296 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote97 views1 answer
Compare two tables to find unmatched records
SQL
0 vote104 views1 answer
Mysql trim characters
SQL
2 votes66 views1 answer
Oracle current date without time
SQL
7 votes112 views3 answers
Python and mysql connectivity
SQL
0 vote104 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote95 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote104 views1 answer
Oracle call a function in a insert statement
SQL
0 vote104 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote104 views1 answer
Compare subqueries oracle
SQL