Export Tables and Fields

[wrbailey]

How would I go about exporting all the tables and their fields?

[jsonsiadek]

It depends on what you are trying to export. You can export students' information by using Quick Export, Custom Student List, Data Export Manager, and DDE. 

[wrbailey]

I'm sorry - I should have been more clear. I'm not trying to export the actual contents of the table, I'm trying to export the names of the tables and the names of the fields. 

[Cindy68]

I need this information as well. Still searching in communities.

[JeffG9]

Download the Data Dictionaries. 

[Cindy68]

Thank you @JeffG9 , I did that but the PDF is not copy and paste friendly and I am not able to convert to excel. What would be ideal is if in the pull down you could choose "all fields" when preparing to export.

[JeffG9]

@Cindy68 you can, if you do the Export in DDA as opposed to DDE. See attached. There are, however, tables not accessible via DDE/DDA. 

[Cindy68]

Oh my heck! Thank you! I have not used DDA yet... Thank you so much!

[JeffG9]

Just be VERY careful in there. We sometimes say it stands for Data Destruction Area. 

[Cindy68]

That I am familiar with 🙂