AnsweredAssumed Answered

Export All Table Names and Field Names (No Records)

Question asked by craig157 on Jul 10, 2017
Latest reply on Jul 10, 2017 by mikebeargie

Afternoon All,

 

I am looking for a way to export all our Tables with the Relevant Field Names.

 

Just as I need to update our UserGuides for future DBAs so would benefit if I could advise what each tables is used for.

 

We only have about 30-40 Tables but each contains atleast 100-500 Fields which I would like to find out which are inactive now.

 

Ideally the table would like look:

 

Table: Names

Field1: Firstname

Field2: Surname

Field3: MiddleName

 

etc etc

 

Thanks!

Outcomes