c#控制台应用程序怎么执行SQL 的ddl语句

Question

SqlConnection con = new SqlConnection(strCon);
string sql = "Exec ('Drop table '+ @tableName)";
SqlCommand cmd = new SqlCommand(sql,con);
cmd.Parameters.AddWithValue("@tableName", tableName);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException se)
{
throw new Exception(se.Message);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}

Answer 1

SqlConnection con = new SqlConnection(strCon);
string sql = "Exec('drop table '''+@tableName+'''')";try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql,con);
cmd.Parameters.AddWithValue("@tableName", tableName);
cmd.ExecuteNonQuery();
}
catch (SqlException se)
{
throw new Exception(se.Message);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}

Answer 2

string sql = "drop table @tableName";
using(SqlConnection con = new SqlConnection(strCon))
{
  con.open();
  SqlCommand cmd = new SqlCommand(sql,con);
  command.CommandType = CommandType.Text;
  cmd.Parameters.AddRange("@tableName", tableName);
  cmd.ExecuteNonQuery();
}