How can i get schema table for MySql query using C#

Question

my code is like this,

but i cannot find data types like int, varchar for particular columns.

MySqlConnection con = new MySqlConnection(connectionString)
con.Open();

var QueryCommand = new MySqlCommand("Select * from Customers", con);
var ResultReader = QueryCommand.ExecuteReader(CommandBehavior.SchemaOnly);

var dt = ResultReader.GetSchemaTable();

this will be helpful. http://stackoverflow.com/questions/681653/can-you-get-the-column-names-from-a-sqldatareader — Dilan Wickramarathna, Apr 28 '17 at 06:43

score 0 · Answer 1 · answered Apr 28 '17 at 06:43

0

You can use

DESCRIBE [databasename].[tablename];

or,

SHOW [databasename].[tablename];

answered Apr 28 '17 at 06:43

user7415073

290
2
17

How can i get schema table for MySql query using C#

1 Answers1