internal static void RemoveTable(string connectString, string tableName)
{
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
try
{
conn.ConnectionString = connectString;
conn.Open();
SqlCommand cmdCreateDb = new SqlCommand();
if(GetTableNamesAsArrayList(connectString).Contains(tableName))
{
cmdCreateDb.CommandText = SqlRemoveTable(tableName);
}
else
{
return;
}
cmdCreateDb.CommandType = System.Data.CommandType.Text;
cmdCreateDb.Connection = conn;
cmdCreateDb.ExecuteNonQuery();
}
catch(Exception ex)
{
throw ex;
}
finally
{
if(conn != null)
conn.Close();
}
}