Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9409 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
What is a dbms wizard?
Explain about builtinadministrator?
What are the basic functions for master, msdb, model, tempdb and resource databases?
Explain sub-query?
Can one drop a column from a table?
What are the different sql server versions?
What is the difference between clustered and a non-clustered index?
What is sql server 2000 work load governor?
How to name query output columns in ms sql server?
Explain few examples of stored procedure over triggers?
How to run sql server 2005 books online on your local system?
What is sql server used for?
What is use of @@ spid in sql server?
How many types of triggers in sql server?
What is the difference between push and pull subscription? : sql server replication
