• mike1234321

    SSC Rookie

    Points: 40

    You end up with the view and underlying tables being named the same, which gives you the following error:  

    Msg 3705, Level 16, State 1, Line 4
    Cannot use DROP VIEW with 'dbo.underlying_table' because 'dbo.underlying_table' is a table. Use DROP TABLE.

    Prefacing the view name with 'v_' or something like that would fix the problem.