Hi Lowell,

Thanks for helping out.

Yes it is the column headers for the INFORMATION_SCHEMA that I am trying to return with the schema information e.g.

TABLE_CATALOG',

'TABLE_SCHEMA',

'TABLE_NAME',

'COLUMN_NAME',

'ORDINAL_POSITION'

etc etc etc

I saw the solution you have offered while I was google'ing, however, the results are being sent to a web page and the site is hosted in a shared environment and I don't have access to the options you are suggesting. I'm sure it can be achieved in a single sql query though, I just can't figure it out!

Any other ideas? 🙂