Help needed in retriveing db reletionships using vba

[method]

Hi experts. I need a help in retriveing primary key,alternatekey,foreign key and lenght of each field
using vba and displaying it in massage box. I be happy if some one show me how i can retrive these information.
Thanks