# User Defined Views missing from linked server

**URL:** <https://community.cdata.com/t/user-defined-views-missing-from-linked-server/103>\
**Category:** CData Drivers\
**Tags:** question, sql-gateway, odbc, linked-server, user-defined-view\
**Created:** [March 24, 2023, 6:09pm UTC](https://community.cdata.com/t/user-defined-views-missing-from-linked-server/103 "2023-03-24T18:09:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elizabeth\_G](https://avatars.discourse-cdn.com/v4/letter/e/6bbea6/32.png) [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\
**Post date:** [March 24, 2023, 6:09pm UTC](https://community.cdata.com/t/user-defined-views-missing-from-linked-server/103/1 "2023-03-24T18:09:01Z")

</div>

I created&nbsp;some User Defined Views for my&nbsp;ODBC driver, but when I use the driver with&nbsp;a linked server, I can’t find them anymore. Is there a way to access them?

---

<div class="post-metadata">

**Author:** ![Elizabeth\_G](https://avatars.discourse-cdn.com/v4/letter/e/6bbea6/32.png) [@Elizabeth\_G](https://community.cdata.com/u/Elizabeth_G)\
**Post date:** [March 24, 2023, 6:11pm UTC](https://community.cdata.com/t/user-defined-views-missing-from-linked-server/103/2 "2023-03-24T18:11:23Z")

</div>

Due to the way that the catalog and schema are used in a linked server, only one schema can be accessed at a time. As User Defined Views are also stored in a different schema, which by default is named UserViews, they aren’t visible in the linked server under the default schema. To access them,&nbsp;you will need to&nbsp;set BrowsableSchemas to UserViews in the DSN, and then restart the SQL Gateway service and refresh the linked server. The User Defined Views will then appear in the linked server.