How do I switch off
SCHEMABINDING for a view without recreating it?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Yes. It's good that you use SCHEMABINDING (we do always) and sometimes you have to remove it to change a dependent object. Just ALTER the view
Won't ALTER VIEW allow for you to get this done? When you create a view you would do:
so, lose the WITH clause: