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

7 votes271 views3 answers
Postgre describe table
SQL
2 votes302 views3 answers
Sql server: how to concatenate column data using comma
SQL
1 vote306 views1 answer
Convert to hexadecimal sql
SQL
0 vote302 views1 answer
Mysqli_connect using prepare statement
SQL
4 votes274 views1 answer
Oracle user tables
SQL
0 vote294 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote278 views1 answer
Composit key in sql
SQL
1 vote289 views2 answers
How to check if sql query is correct online
SQL
-1 vote308 views2 answers
Installing mysql on centos 7
SQL
14 votes300 views2 answers
Oracle add column with default value
SQL