Re: How to check if the database and tables exist through connector.NET

[Fernando Gonzalez]

Hi,

A good approach would be to use the information_schema database (which is supported since MySql 5.0, see http://dev.mysql.com/doc/refman/5.0/en/information-schema.html)

For example to read all the column data (data type, length, precision, etc.) from the table test2, you will use the table 'columns':

select * from information_schema.columns where table_schema = 'test2'