We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Read all tables inside a database

Comments

1 comment

  • Avatar
    Adrian Williams

    The Database Profiler node and Database Metadata node can be used to obtain the metadata from a database, see the node Help documentation. 

    The JDBC Query node can be parameterized to source the value of the 'SqlQuery' property from an input field. The results sets for each input query are concatenanted using the method specified by the 'ConcatenationMode' property. When the property value is set to 'Union' the resulting output of the node will be combine all the fields from each of the queries, with Null values for fields not present in a given result set.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.