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

0 vote318 views2 answers
Sql trigger difference between for and after
SQL
0 vote342 views1 answer
Date datatype in livesql
SQL
0 vote339 views1 answer
Sql pivot table
SQL
0 vote322 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote331 views1 answer
Foreign key type uniqu mysql
SQL
0 vote318 views1 answer
Mysql query to add hours to column in table
SQL
1 vote296 views1 answer
How to print longest name in sql
SQL
0 vote294 views1 answer
Get all employees if name ends with in sql
SQL
0 vote310 views1 answer
Sql anywhere create procedure
SQL
3 votes319 views2 answers
Oracle grants
SQL