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 vote118 views1 answer
Mysql select from outside
SQL
0 vote127 views1 answer
Neo4j command to run script file
SQL
0 vote131 views1 answer
Sql date time query find
SQL
0 vote112 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
1 vote121 views1 answer
Install postgresql on raspberry pi
SQL
0 vote115 views1 answer
List MySQL Table and Index Size
SQL
0 vote127 views1 answer
Mssql last day of month
SQL
0 vote156 views1 answer
Sql query for login with email or username
SQL
1 vote75 views2 answers
Last working day in week date function in sql
SQL
0 vote125 views1 answer
Postgresql print sessions using the database
SQL