How the column order determined RRS feed

  • Question

  • Hi,

    I have views doing basically “select * from base_table where condition”.

    I noticed that the order of the columns is not ideal, so I drop and recreated the base_table with correct column order.

    However, all my above views are still showing the old column order.

    I tried to reorder the columns myself, close and restart SSMS, etc, nothing works.

    Please help.


    Thursday, August 2, 2012 2:00 PM


  • I recreated the view. Now AOK.


    • Marked as answer by smetah Thursday, August 2, 2012 2:04 PM
    Thursday, August 2, 2012 2:04 PM