C# mysql 获取所有表名
public static List<string> GetAllTableName()
{
List<string> retNameList = new List<string>();
DataTable tbName = m_Connectioin.GetSchema("Tables");// 这句是关键 Connectioin为连接 使用的是Mysql.Data.dll
if (tbName.Columns.Contains("TABLE_NAME"))
{
foreach (DataRow dr in tbName.Rows)
{
retNameList.Add((string)dr["TABLE_NAME"]);
}
}
return retNameList;
}