Schema Browser Script tab for Views does not show entire Create SQL. (4224086)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Schema Browser Script tab for Views does not show entire Create SQL.
Description

Schema Browser Script tab for Views does not show entire Create SQL and only shows the underlying Select statement for the view. How to get the entire Create or Replace statement for the view?
Resolution

1. In Script tab there will be a few icons listed in its toolbar
2. Select the first icon, "View/Edit Script Options" icon
3. Select the View tab from dialogue window and uncheck “Query Only” checkbox. Hit OK.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title