chris.obrien.07 asked:

I have been creating an application recently and I need some help on database table schemas. I have programmed the application in vb.net 3.5 using a mysql database.

What the application does is not really important… except that I am trying to get the schema for a table in the database. To date the way I have been getting the schema for a table in the database is as follows

I am seeking a way of getting the schema for the table above without having to execute the select command. This will help me in my quest to make my app work with more than one DB provider. I don’t want my app to have any SQL commands if at all possible. (my intention is to only use stored procedures in the database)