Take the table fields and their data types, field length in excel

Hi All,

Can anyone tell me in AX 2012 how to take the table fields and their data types, field length in excel.

If anyone know the answer please reply

You can find this information in SqlDictionary table. Or you can extract it from AX through reflection (Dict* classes).