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

5 votes118 views1 answer
Minecraft java port number
SQL
7 votes115 views2 answers
Show size database mysql
SQL
0 vote113 views1 answer
Stop psql server windows
SQL
0 vote119 views1 answer
Calculate age in sql
SQL
0 vote124 views1 answer
Add mysql database to power bi web
SQL
0 vote127 views1 answer
How to check database engine in mysql
SQL
1 vote130 views1 answer
Tsql get beginning of year
SQL
0 vote111 views1 answer
Mssql describe stored procedure sqlcmd
SQL
20 votes110 views5 answers
Mysql reset auto increment to 1
SQL
0 vote116 views1 answer
Mysql root permission denied lost
SQL