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

1 vote130 views1 answer
Mamp mysql path mac
SQL
4 votes112 views1 answer
Sql list users and roles
SQL
0 vote131 views1 answer
Sql min
SQL
0 vote128 views2 answers
Select limit ms sql
SQL
0 vote281 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote128 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
21 votes146 views4 answers
Add column mssql
SQL
0 vote134 views1 answer
Psql list view rules
SQL
0 vote135 views1 answer
Mysql vs sql server performance benchmark
SQL
12 votes140 views4 answers
Psql command not found
SQL