Is there a way (similar to the below code) to delete all the rows in a specified table using c#?
SqlConnection con = new SqlConnection(conString);
con.Open();
string sql = @"DELETE*FROM compsTickers;";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
Right now i'm getting an error:
Incorrect syntax near '*'
You don't specify columns DELETE FROM compsTickers is enough.
(Also TRUNCATE TABLE compsTickers will do, it's a different way of deletion, that could make sense depending on your transaction log settings)
Just remove the * as it isn't needed to for DELETE statements
string sql = @"DELETE FROM compsTickers;";
DELETE (Transact-SQL) (link)
FROM is optional. You're always DELETing from a table, so all you needed was (you don't even need a statement delimiter, for a single statement):
DELETE compsTickers
Which empties the table