How to get list of all tables used in a given universe

sdk development
5

If you run this VBA procedure in the report

Sub ShowSQL()
  Dim myDPs As DataProviders
  Dim myDP As DataProvider
  
  Set myDPs = ActiveDocument.DataProviders
  
  For Each myDP In myDPs
    MsgBox myDP.SQL
  Next
End Sub

It will display the SQLs of all data providers. In SDK section of BOB you can find more examples of the same. Maybe also some example how to automate this process for more reports and/or how to log the SQLs into text file.

Have a look also at this utility.

[Moderator Note: I am moving this ropic to SDK]

Marek Chladny :slovakia: (BOB member since 2003-11-27)