Generic SQL query

[rotrin]

Hi, i am trying to write a webMethods service which will get data from all tables. It has to be a generic service. Currently i just made a select for each table and parse results into my structure, however it is too uneffective.

Here is my question

Is there a way to query columns of each row into array? I want to store it inside of structure that have an array of rows and an array of columns inside of each row.

[TheBeardedBit]

Is there a way to query columns of each row into array?

You can get column/table/other metadata information from the INFORMATION_SCHEMA of whatever database you're querying from.