CREATE VIEW does not change to ALTER after compile

  • I'm a newbie to the site, but have been playing with SQL for some time now.

    We recently upgraded from SQL7 to SQL2000 and now when I design a new view and use CREATE VIEW ... the code does not change to ALTER VIEW after compiling.

    This worked fine before our upgrade. Any insites on this?


    Kindest Regards,

    Tommy D

  • When you need to change the view, just change it to alter view. It's just the way things work in 2000

Viewing 2 posts - 1 through 2 (of 2 total)

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