/// <summary>
/// List all tables in the database.
/// </summary>
/// <returns>List of strings, each being a table name.</returns>
public List <string> ListTables()
{
List <string> tableNames = new List <string>();
DataTable result = Query(MysqlHelper.LoadTableNamesQuery());
if (result != null && result.Rows.Count > 0)
{
foreach (DataRow curr in result.Rows)
{
tableNames.Add(curr["Tables_in_" + _Settings.DatabaseName].ToString());
}
}
return(tableNames);
}