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
- 8951 Views
- I also Faced
- E-Mail Answers
Answer Posted / bruhaspathy
You cannot add a column at that particular position that you wanted. Instead the workaround is that you add the column using the Alter Table command and then after the columns are created, you can go to object explorer and right click the table, select modify and then move the column to the desired column location you wanted.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Tell me in brief how sql server enhances scalability of the database system?
What are rest-style architecture's?
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?
How to join two tables in a single query in ms sql server?
Can we call future method from queueable?
Can binary strings be used in arithmetical operations?
How does clustered and non clustered index work?
What is hot add cpu in sql server 2008?
How can you know if the row fetched from cursor is still valid in underlying table?
How to locate and take substrings with charindex() and substring() functions?
How do clustered indexes store data?
What are the differences between user defined functions and stored procedures?
Explain sub-query?
What is surrogate key? : sql server analysis services, ssas
How can sql injection be stopped? : sql server security
