Home Forums Article Discussions Article Discussions by Author Discuss content posted by Cameron Wells Refreshing Views RE: Refreshing Views

  • February 8, 2010 at 3:57 pm

    #1115846

    ...when I needed to refresh all views, I was used to create the script with all DROP and CREATE for all views,...

    If/when you do this-- be sure you grab the permissions before dropping. Why not use ALTER instead?

    Cursors are useful if you don't know SQL