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 vote112 views1 answer
Sql select min
SQL
0 vote106 views1 answer
Pgsql is not permitted to log in
SQL
3 votes115 views1 answer
Get all elements sql
SQL
7 votes110 views1 answer
Minecraft forge server host
SQL
0 vote112 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote107 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote110 views1 answer
Typeorm raw sql
SQL
0 vote62 views1 answer
Check id exist or not in sql
SQL
0 vote109 views1 answer
SAP Return
SQL
0 vote117 views1 answer
Enable sql server full text indexing
SQL