MySqlCommand get full response as string?

Question

MySQL

It is necessary from the response to - to get the full response of the server in order to parse and find the Constraint for the primary key. That is - for example, in phpMyAdmin - it looks like this: How to pull out the entire response as one line in c#?SHOW CREATE TABLE <my_table_name>

sql = "SHOW CREATE TABLE `" + TableName_textBox.Text + "`";
                command = new MySqlCommand(sql, conn);
                reader = command.ExecuteReader();
                 reader.Read();

                string s = ??????

Or is there another way besides parsing the response - to get the foreign key and the field of the parent table it refers to?

Answer 1

I believe that there is still a way through information_schema and it is more correct than output parsing
As an example:
https://dba.stackexchange.com/questions/102371/how...

Answer 2

SqlDataReader reader = command.ExecuteReader();
        while (reader.Read())
        {
            Console.WriteLine(String.Format("{0}", reader[0]));
        }

https://docs.microsoft.com/en-us/dotnet/api/system...