title: how to get all details about a mysql table using c#?
body: <p>I want to retrieve these info for a mysql table using c# </p>
  
  <p>1) Complete column definitions including name, size and data type, and extra info like null/not null, unsigned,auto increament, default values, if data type is enum, the accepted values</p>
  
  <p>2) All constraints - Primary/Foreign/Check/Unique</p>
  
  <p>3) All indexes</p>
  
  <p>I can get column related basic info using "describe table_name" query against the database.</p>
  
  <p>but how to fetch all these info?</p>
  
  <p>regards,
  Anjan</p>