Retrieving enum information

Question

Hi I'm using the MySqlDataReader object to get information from a DB after sending a select query. I need to find out which columns are returned and the myReader.GetDataTypeName(int) works fine. However some columns might be of the ENUM type. For that I have 2 questions: 1. How do I check whether or not a column is of enum type? 2. How do I retrieve all valid entries for an enum column? In a given retrieved relation only the values 'red' and 'blue' might appear but I need to know what other types are valid. F.g 'orange'. Any help is greatly appreciated.

Andrzej Wegierski · Answer

Such informations aren't stored in typical database column. You can try to do this by creating check constrainsts and examine them for instance. Check database schema using GetOleDbSchemaTable() method or something from Your Connection object.