How To Change Column Ordinal Position in SQL Server 2005
using Query i.e I Want To Add Column at Particular Ordinal
Position in SQL Server 2005

Answer Posted / soorai ganesh

Hi Buddy,

Its not possible in SQLSERVER. If u want to add column in
particular ordinal position you have to drop the table and
have to create again the same table with your ordinal
choice. Incase if u have data in table, get them into one
temporary table and drop the table and recreate the table
again. then restore the data from temporary table..........

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please explain what is “asynchronous” communication in sql server service broker?

744


Explain unique key in sql server?

762


What is database replication? What are the different types of replication you can set up in sql server?

706


Where to find ntwdblib.dll version 2000.80.194.0?

784


What is order of B+tree?

909


How will you optimize a stored procedure optimization?

725


What is the cartesian product of table?

774


What to perform pattern match with the like operator?

700


What is the meaning of lock escalation and why/how to stop this? : sql server database administration

833


What is sub-query in sql server? Explain its properties.

866


What is the use of @@spid?

783


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

803


Explain the properties of subqueries in sql server?

779


How to convert numeric values to integers in ms sql server?

748


What is the difference between set and select?

794