title: Find Column Data type in linked server
body: <p>I just started working on a new project where data is stored in linked server. I have to add new columns to a table in staging environment, which already exists under same table name in linked server.</p>
  <p>I have dumped data into a temp table but all the columns with data type decimals, int and numerics are converted into float in staging database. Also, when I'm trying to access information_schema or sys.columns for metadata getting below error. Any workaround to see the data type of table columns in linked server ?</p>
  <pre><code>select * from openquery(LINKEDSERVER,'select * from information_schema.columns')
  </code></pre>
  <p>Error:</p>
  <pre><code>OLE DB provider &quot;MSDASQL&quot; for linked server &quot;LINKEDSERVER&quot; returned message &quot;[LINKEDSERVER][ODBC 64bit driver][OpenAccess SDK SQL Engine]Base table:columns not found.[10129]&quot;.
  Msg 7321, Level 16, State 2, Line 45
  An error occurred while preparing the query &quot;select * from information_schema.columns&quot; for execution against OLE DB provider &quot;MSDASQL&quot; for linked server &quot;LINKEDSERVER&quot;. 
  </code></pre>
  <p>Thanks in advance.</p>