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.