# Schema Browser - Script not obeying setting(i think)

**URL:** <https://forums.toadworld.com/t/schema-browser-script-not-obeying-setting-i-think/59276>\
**Category:** Toad for Oracle - Beta\
**Created:** [April 19, 2024, 4:55pm UTC](https://forums.toadworld.com/t/schema-browser-script-not-obeying-setting-i-think/59276 "2024-04-19T16:55:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [April 19, 2024, 4:55pm UTC](https://forums.toadworld.com/t/schema-browser-script-not-obeying-setting-i-think/59276/1 "2024-04-19T16:55:25Z")

</div>

I go to schema browers "script" tab. I have the setting set to format objects. But when I first go into the tab, nothing is formatted. I need to click "format" to format the script. Am I doing something wrong

1st click:

 ![image](https://global.discourse-cdn.com/quest/original/3X/3/a/3a05a3bc7fc4ffa220e23b6b97a6c85d6b172d7a.png)  
After format(ctrl 'f')  
 ![image](https://global.discourse-cdn.com/quest/original/3X/e/9/e9af2125c3043644ee0d57706802440b1951bbe7.png)

my settings:

 ![image](https://global.discourse-cdn.com/quest/original/3X/6/8/68e70e6d05a7a37e41d22727e486e1afd289697a.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [April 19, 2024, 4:57pm UTC](https://forums.toadworld.com/t/schema-browser-script-not-obeying-setting-i-think/59276/2 "2024-04-19T16:57:58Z")

</div>

Check the options in your screen shot again. You have "One line per statement" checked. Uncheck that.

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [April 19, 2024, 5:01pm UTC](https://forums.toadworld.com/t/schema-browser-script-not-obeying-setting-i-think/59276/3 "2024-04-19T17:01:30Z")

</div>

Thank you. I did not think "one line" was the issue.

2nd issue, same place. (I hit enter before I finished typing)

how do I get "compute statistics" when in the same tab for indexes.  
 ![image](https://global.discourse-cdn.com/quest/original/3X/f/b/fb29e323cc24d040fa90d02ac5fdecb39f66206c.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [April 19, 2024, 5:06pm UTC](https://forums.toadworld.com/t/schema-browser-script-not-obeying-setting-i-think/59276/4 "2024-04-19T17:06:39Z")

</div>

Looks like that's not possible. There is a setting in script options if you go to SB-Indexes-Script, but it's not accessible from tables. I can add that.

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [April 19, 2024, 6:36pm UTC](https://forums.toadworld.com/t/schema-browser-script-not-obeying-setting-i-think/59276/5 "2024-04-19T18:36:18Z")

</div>

I might be wrong, but in the past, the settings used by the "script" tab was the same as "export ddl"  
 ![image](https://global.discourse-cdn.com/quest/original/3X/6/e/6ebc61c81fda013c4ef520ecd419b4a1dbafdd92.png)

I must have used the SB index tab, but I a rarely use that tab and I would drill down to the table prior the index. I must be wrong. Thanks.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [April 19, 2024, 7:03pm UTC](https://forums.toadworld.com/t/schema-browser-script-not-obeying-setting-i-think/59276/6 "2024-04-19T19:03:14Z")

</div>

If you go to SB-Tables-RHS-Indexes, then click the first toolbar button you can get the Compute Statistics option there. That's the only other way that I can think of.
