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

14 votes189 views2 answers
How to auto increment in sql
SQL
0 vote184 views1 answer
Mysql convert charset
SQL
0 vote204 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
2 votes201 views1 answer
Oracle convert run_duration to number
SQL
0 vote197 views2 answers
Pop sql insert value into
SQL
0 vote330 views4 answers
Stored procedure sql
SQL
-1 vote180 views2 answers
How to select the lowest values from table per client sql
SQL
7 votes213 views6 answers
Mysql group concat
SQL
3 votes225 views2 answers
Sqlite show table definition
SQL
1 vote194 views2 answers
Extract weekday from date in sql
SQL