Toad World® Forums

how do I copy a view

What is the easiest way to copy a view to a test view name so I can modify and test it?

Find the view in the Schema Browser. Go to the script tab. Click “copy script to editor” button (on the script tab’s toolbar).

That will open an Editor and put that source code in it. Then you can just change the name and whatever else you want in the script, and F9 to create it.

Thank you

Can I copy this. I am so new to this and I need to do this one step at a time.

If you have a question, I don’t understand what it is. Please be specific.