Post reply

Editing a View

  • November 28, 2011 at 8:08 am

    #390966

    Hello,

    I have a view called Difference_Index_Scanned, in one of my databases.

    All I am trying to do is edit the view as the TSQL is not quite correct.

    Within Server Management Studio I find the view, right click it and choose Edit. I make the change, but the when I try and save it, it saves is as " SQLQuery13.sql" (as an example) and doesn't actually change the view.

    How do I make a change to the view?

    Thanks

  • November 28, 2011 at 8:16 am

    #1413466

    You need to run the script, by pressing F5 or the execute button on the toolbar with the red ! mark

  • November 28, 2011 at 8:21 am

    #1413470

    Argh! Stupid me.

    Thanks so much. Was driving me mad.

  • November 28, 2011 at 8:25 am

    #1413471

    not to worry, happy to help, is always the simple things that wind you up the most.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply