I want to have the ability in my application to edit a view. Where can I find where the actual syntax for a view is actually stored in the database? For instance if I have a vew called vwMyNumber which is "select customernumber from customer where Type = 1" I can see the view in sysobjects but where is the actaul command for the view stored?
BTW, this is in SQL 2000. I don't see a slot for that here on EE.