Add a new table column to specific ordinal position in Microsoft SQL Server

by

You have to create a temp table that mirrors the original table’s schema but with the column order that you want, then copy the contents of the original to temp. Delete the original and rename the temp.

This is what SQL Management Studio does behind the scenes.

With a schema sync tool, you can generate these scripts automatically.

More Related Contents:

  1. How do I get list of all tables in a database using TSQL?
  2. SQL count rows in a table
  3. SQL Server – error when creating stored procedure
  4. How do I use cascade delete with SQL Server?
  5. SQL Server insert if not exists best practice [closed]
  6. Copy tables from one database to another in SQL Server
  7. An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
  8. Are GUID collisions possible?
  9. How to add Active Directory user group as login in SQL Server
  10. Maximum size of a varchar(max) variable
  11. Does a foreign key automatically create an index?
  12. best way to convert and validate a date string
  13. SQL Server pivot vs. multiple join
  14. SQL Server Bulk insert of CSV file with inconsistent quotes
  15. Real vs. Floating Point vs. Money
  16. SQL Server Query: Fast with Literal but Slow with Variable
  17. How can I make HTTP request from SQL server?
  18. Saving changes after table edit in SQL Server Management Studio
  19. An attempt to login using SQL authentication failed
  20. Format SQL in SQL Server Management Studio
  21. Parse XML in SQL Server
  22. SQL Server, the misleading XLOCK & optimizations
  23. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  24. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  25. Grant Select on a view not base table when base table is in a different database
  26. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  27. Database design: Calculating the Account Balance
  28. migrate data from MS SQL to PostgreSQL?
  29. INFORMATION_SCHEMA vs sysobjects
  30. Does query plan optimizer works well with joined/filtered table-valued functions?

Leave a Comment