Via the CLI tool `isql` I was able to retrieve column metadata using the "HELP TableName" command / query, but trying to send the same query via MSSQL linked server only produces an error:
SELECT * FROM OPENQUERY (SF_LINKED_SERVER_NAME, 'HELP Account')
[Devart][ODBC][Salesforce]You have an error in your SQL syntax. at line 1, column 1: Unexpected symbol 'HELP'..".
Msg 7350, Level 16, State 2, Line 1
Is there anyway to get the same column metadata I was able to retrieve via sqli CLI tool but via a MSSQL linked server setup instead?
Googling this question lead me to the system stored procedure `
sp_columns_ex` - but sadly this only returns empty result sets when used on a Devart ODBC Salesforce linked server - probably for the same reason that the MSSQL Management Studio Object Explorer does not offer to expand the listed tables to reveal column definitions.