Home Forums SQL Server 2005 T-SQL (SS2K5) SQL-Server 2005: Change Ordinal Column Position RE: SQL-Server 2005: Change Ordinal Column Position

  • March 31, 2008 at 4:58 am

    #795846

    baumgaertner (3/31/2008)

    Thank you for you answer, Karl.

    But I do not want to rename the table and then insert the data to the new table.

    When you have big tables this approach is slow.

    Are there no alternatives?

    Unfortunately I don't think there's any other way. Is there any reason why you want to change the column position? It shouldn't really matter what position it's in.

    Karl
    source control for SQL Server