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
- 2 Answers
- 8920 Views
- I also Faced
- E-Mail Answers
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
Tell me what are the advantages of using stored procedures?
what is denormalization and when would you go for it? : Sql server database administration
Would you store your query in a ssrs report or a database server? State the reason why?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
How to select some specific rows from a table in ms sql server?
Explain linked server in sql?
How can I change procedure name in sql server?
What are the differences between stored procedure and view in sql server?
What is amo? : sql server analysis services, ssas
Does sql server 2000 clustering support load balancing?
What are the different kinds of ssrs reports?
Write down the syntax and an example for create, rename and delete index?
how to use DTS package in 2000,2005,2008 in sql server
what exactly sql injuction.how to overcome.....
What do you understand by hotfixes and patches in sql server?
