We can not Add any column middle of the existing tab;le structure... without Re-Create the table (Drop and Create)
But, we have some alternate steps here...
If the table already have Id, Name, Place on tbl_cosmetics. OK
If you want to add a new column called Phone next to Name column... like
Id, Name, Phone, Place
/*Copy and Create a new table along with your new column structure(Inclusing column length, Data type)*/
Select Id, Name, Cast('' as Varchar(15)) As Phone, Place Into tbl_cosmetics_Temp from tbl_cosmetics
/*Change your actual table name to something else*/
EXEC Sp_Rename 'tbl_cosmetics','tbl_cosmetics_Old','Object'
/*Change the new table to your actual name*/
EXEC Sp_Rename 'tbl_cosmetics_Temp','tbl_cosmetics','Object'
1. Before you start this acivity, take a note on constraints / Indexes
2. You have to apply all constraints and Indexes again once you done the above steps...
Akiii, if this helps please login to Mark As Answer. | Alert Moderator