SQL Server Performance Forum – Threads Archive
Global Change to all Views in DB
Hi. Can you tell me where views are stored? I need to make some global modifications to some variables. Is there a way to do this without opening each one individually? Thank you.
View definitions are stored in ‘syscomments’ table. You can a run query like below to view these definitions. But, I don’t know if you can directly modify them. select text from syscomments where id in (select id from sysobjects where xtype = ‘V’)
I would generate one single script with EM, make your changes then execute this script. Just make sure you include all options you need when generating that script.
Refrain from modifying the system tables in any case directly, follow as suggested by Frank. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.