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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
What r sql reporting services and analysis services? how can we use it.
How many types of functions are there in sql server?
What is a recursive stored procedure in sql server?
Explain “row_number()” in sql server with an example?
What is scrollable cursor?
How ssrs maintain security?
How much does sql server 2016 cost?
What type of Index will get created after executing the above statement?
Which are the olap features?
Why the trigger fires multiple times in single login?
What program is used to store the data source file?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)