# Explorer Schema

**URL:** <https://forums.toadworld.com/t/explorer-schema/58054>\
**Category:** Toad for IBM DB2\
**Created:** [August 29, 2023, 5:55pm UTC](https://forums.toadworld.com/t/explorer-schema/58054 "2023-08-29T17:55:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cat](https://avatars.discourse-cdn.com/v4/letter/c/d07c76/32.png) [@cat](https://forums.toadworld.com/u/cat)\
**Post date:** [August 29, 2023, 5:55pm UTC](https://forums.toadworld.com/t/explorer-schema/58054/1 "2023-08-29T17:55:49Z")

</div>

Hi, I have to set the Schema under Explorer tab each time.  
 ![image](https://global.discourse-cdn.com/quest/original/2X/1/183345b6d42ff8b187aefee9bea3357800998e54.png)

How can I set so that it defaults to DB2 by default?

Thank you.

---

<div class="post-metadata">

**Author:** ![Gita.Sharifi](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gita.sharifi/32/16973_2.png) [@Gita.Sharifi](https://forums.toadworld.com/u/Gita.Sharifi)\
**Post date:** [September 5, 2023, 2:00pm UTC](https://forums.toadworld.com/t/explorer-schema/58054/2 "2023-09-05T14:00:59Z")

</div>

Hi,  
Try the Tools | Configuration Wizard menu option. The last step of the wizard lets you choose the DB Explorer to open by default.

![image](https://global.discourse-cdn.com/quest/original/2X/6/66bf3a5504da0e74376d985f0b39bb432127f48d.png)

---

<div class="post-metadata">

**Author:** ![cat](https://avatars.discourse-cdn.com/v4/letter/c/d07c76/32.png) [@cat](https://forums.toadworld.com/u/cat)\
**Post date:** [September 5, 2023, 4:13pm UTC](https://forums.toadworld.com/t/explorer-schema/58054/3 "2023-09-05T16:13:33Z")

</div>

Hello @Gita.Sharifi . I checked Tools --\> Configuration Wizard. On the Layout and Settings screen I selected "Custom" --\> Next --\> Look and Feel: Next --\> Database Explorer Style: Next --\> Startup Connections: Next --\> Connection Documents, I select "Open a new Database Explorer" --\> Finish

This did not set the schema in Explorer to DB2  
 ![image](https://global.discourse-cdn.com/quest/original/2X/e/e075d01a2ce01a8fd3bf44693593914ecbbc9f73.png)

---

<div class="post-metadata">

**Author:** ![Gita.Sharifi](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gita.sharifi/32/16973_2.png) [@Gita.Sharifi](https://forums.toadworld.com/u/Gita.Sharifi)\
**Post date:** [September 5, 2023, 5:02pm UTC](https://forums.toadworld.com/t/explorer-schema/58054/4 "2023-09-05T17:02:05Z")

</div>

Ok, try changing the default schema in Connection Properties window - Default Schema field.  
Hope that helps out.
