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
How do I create a stored procedure in sql server?
what are constraints? Explain different types of constraints? : Sql server database administration
Is the order of columns in the set clause important in ms sql server?
How to find out the list schema name and table name for the database?
Explain differentiate between a having clause and a where clause?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Why people hate cursor?
How to insert multiple rows with one insert statement in ms sql server?
What is RMS migrations?
Explain can you implement data mining in ssrs?
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?
What is built-in function?
Explain go command in sql server?
What is format parameter in ssrs?
What are a scheduled jobs?