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

8 votes148 views1 answer
C# textboxaccept only numbers
C#
7 votes176 views2 answers
How to instantiate as child unity
C#Unity
2 votes147 views3 answers
C# generic type converter
C#
1 vote133 views1 answer
Make an enemy go towards player unity
C#
1 vote125 views1 answer
How to check file path is valid in c#
C#
0 vote142 views1 answer
DateTime2 error in EF Blazor Web Application
C#
1 vote128 views1 answer
C# convert seconds to hours minutes seconds
C#
3 votes142 views1 answer
Add dependency injection .net core console app
C#
4 votes142 views2 answers
C# how do you check if a string contains only digits
C#
-1 vote132 views1 answer
C# declaration definition
C#