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
- 9379 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 field with example?
What are number line correlation administrators will use while working with a subquery?
Explain different backup plans?
what is the difference between Delete and Truncate command in SQL
What is a user-defined function in the sql server and what is its advantage?
What are the transaction properties?
What is function of ROLLUP ?
What is a partition function in sql server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is spatial and temporal data?
What is a hint?
Explain contrast amongst grouped and non-bunched records?
what is denormalization? : Sql server database administration
Explain few examples of RDBMS?
What are the underflow and overflow behaviors on float literals?
