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 vote121 views1 answer
Do postgresql
SQL
0 vote130 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote130 views1 answer
Const pool = mysql.createpool()
SQL
0 vote117 views1 answer
Mysql config address
SQL
0 vote154 views1 answer
Get total and distict row diff in sql
SQL
0 vote126 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
5 votes81 views1 answer
Postgres upsert
SQL
0 vote160 views2 answers
Sql update multiple tables
SQL
0 vote131 views1 answer
Use mysql in java program
SQL
1 vote136 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL