title: How to Drop Table [LINKED_SERVER_POSTGRESQL].[DATABASE_NAME].[PUBLIC].[TABLE_NAME]?
body: <p>I made a linked PostgreSQL server on SQL Server, then I want to delete the existing table on the PostgreSQL through the stored procedure that I created on SQL Server.</p>
  
  <p>When I execute the following SQL:</p>
  
  <pre><code>SELECT *
  FROM OPENQUERY (LinkedSrvrName, ' DROP TABLE Database. MyTab SELECT NULL ') 
  </code></pre>
  
  <p>An error appears like this OLE DB provider</p>
  
  <blockquote>
    <p>"MSDASQL" for linked server "POSTGRE_2_14" returned message "ERROR: syntax error at or near" SELECT "; No query has been executed with that handle ".MSG 7350, Level 16, State 2, Line 1 Cannot get the column information from OLE DB provider "MSDASQL" for linked server "POSTGRE_2_14"</p>
  </blockquote>
  
  <p>Can anyone can help?</p>