I've noticed this too... Seems that the view is stored very specifically and changes to the underlying tables don't propagate to the view definitions.
Reasons behind the design... I suspect it has to do with performance. At 11:52 AM 12/16/02, you wrote: >:> What DB? > >MS SQL Server 7 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com