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
- 9321 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
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What are different types of replication in sql server?
What is Dependency Injection and provide example?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Can you roll back the ddl statement in a trigger?
What is the difference between for trigger and after trigger?
Explain relational data?
What is the significance of null value and why should we avoid permitting null values?
How does a profiler work?
How to verify a user name with sqlcmd tool?
Explain how dts is used to extract, transform and consolidate data?
How to assign new column names in a view?
Explain filtered indexes benefits?
How many types of triggers in sql server?
What is the data type of time?
