METHOD 1 : USING T-SQL In this method, we need to first drop the computed column and then add it as a new column to accommodate the altered computed column in any table. But hang on a second, instead of pressing the save button, press the generate script button to see what changes SSMS will implement in case of pressing save button
But do you know what will be the solution when ID column is referenced as foreign key in other multiple tables? because in this case it wouldnt let me delete that old ID column. can i chaneg the order of columns in a table as i dont want to disturb the column sequence of my primary key column after using the above suggested methods
SQL Server Forums - Alter table - Add new column in between..
Make sure you run it in pieces.Here is the code: USE Northwind GO PRINT 'This script attempts to reorder a column by updating the system tables themselves. For any column, it is the number of columns in that table with colid's not greater than its own colid.I use similar logic all the time to calculate rankings, with the rank of a given record being 1 + the number of higher-valued records
First of all, If there is any application which depends on the order of column it is really not good programming and will create problem for sure in future. With the time passing, the developper must add a colum like Deathday, as the life is not eternal, to notify the death of our preferred singer Miachael Kackson for example
sql server 2008 - Alter table column for primary key and identity - Stack Overflow
You have to create a new column with the IDENTITY property: ALTER TABLE MyTable ADD NewID int IDENTITY(1,1) not null Unfortunately, you're not then able to assign the old ID values to this new column
No comments:
Post a Comment