Posted onDecember 15, 2011 by Josephine update column name if I want to rename ModifiedBy to LastModifiedBy ALTER TABLE dbo.Safety DROP COLUMN ModifiedBy ADD LastModifiedBy nvarchar(50)