Hi,
I'm from sweden and did just buy this lovely software:icon_clap: so this is my first post.
I have start to play with it and I really enjoy:sign0060:
I did find those syntax to delete all records from a table here at w3schools:
DELETE FROM table_name
or
DELETE * FROM table_name
I have try both but get syntax error so I use to DROP and CREATE
DB.ExecNonQuery("DROP TABLE table_name")
DB.ExecNonQuery("CREATE TABLE table_name(Name TEXT, Value NUMERIC)")
Is there any other syntax to delete all records from a table?
Thanks!
I'm from sweden and did just buy this lovely software:icon_clap: so this is my first post.
I have start to play with it and I really enjoy:sign0060:
I did find those syntax to delete all records from a table here at w3schools:
DELETE FROM table_name
or
DELETE * FROM table_name
I have try both but get syntax error so I use to DROP and CREATE
DB.ExecNonQuery("DROP TABLE table_name")
DB.ExecNonQuery("CREATE TABLE table_name(Name TEXT, Value NUMERIC)")
Is there any other syntax to delete all records from a table?
Thanks!