title: How to get table's metadata from linked server (SQL Server)
body: <p>How to get tables metadata from linked server/another database? The query below works ideally when running on the main server, but returns null if calls remote server or even another database.</p>
  <pre><code>select object_name(major_id)
  from server.bd1.sys.extended_properties
  </code></pre>
  <p>Probably, it is caused that the specific path for metadata functions (like object_name()) is not defined. Hence, functions take data not from remote server/DB, but server and DB they are launched.</p>
  <p>If it is true, would you prompt the specific path (DB, schema) of metadata functions that I could define path explicitly.</p>
  <p>Thank you for help.</p>