如何使用c#获取有关mysql表的所有详细信息？

Install-Package MySql.Data

using System;
using MySql.Data.MySqlClient;

namespace GetMySQLTableDetails
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "server=localhost;user=root;password=your_password;database=your_database";

            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                try
                {
                    connection.Open();

                    string query = "SELECT * FROM information_schema.tables WHERE table_schema = 'your_database'";

                    MySqlCommand command = new MySqlCommand(query, connection);
                    MySqlDataReader reader = command.ExecuteReader();

                    while (reader.Read())
                    {
                        string tableName = reader.GetString("TABLE_NAME");
                        string tableType = reader.GetString("TABLE_TYPE");
                        string tableRows = reader.GetString("TABLE_ROWS");
                        string tableCollation = reader.GetString("TABLE_COLLATION");

                        Console.WriteLine($"Table Name: {tableName}, Table Type: {tableType}, Table Rows: {tableRows}, Table Collation: {tableCollation}");
                    }

                    reader.Close();
                }
                catch (Exception ex)
                {
                    Console.WriteLine($"Error: {ex.Message}");
                }
                finally
                {
                    connection.Close();
                }
            }
        }
    }
}