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

How do I create a stored procedure in sql server?

720


what are constraints? Explain different types of constraints? : Sql server database administration

696


Is the order of columns in the set clause important in ms sql server?

742


How to find out the list schema name and table name for the database?

729


Explain differentiate between a having clause and a where clause?

706


What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

813


Why people hate cursor?

921


How to insert multiple rows with one insert statement in ms sql server?

836


What is RMS migrations?

1912


Explain can you implement data mining in ssrs?

122


If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

754


What is built-in function?

732


Explain go command in sql server?

761


What is format parameter in ssrs?

130


What are a scheduled jobs?

726