title: DELETE*FROM table
body: <p>Is there a way (similar to the below code) to delete all the rows in a specified table using c#?</p>
  
  <pre><code>SqlConnection con = new SqlConnection(conString);
  con.Open();
  
  string sql = @"DELETE*FROM compsTickers;";
  SqlCommand cmd = new SqlCommand(sql, con);
  cmd.ExecuteNonQuery();
  con.Close();
  </code></pre>
  
  <p>Right now i'm getting an error: </p>
  
  <blockquote>
    <p>Incorrect syntax near '*'</p>
  </blockquote>