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.
Eliz

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.
–Frank
http://www.insidesql.de

Refrain from modifying the system tables in any case directly, follow as suggested by Frank. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>