update column name

if I want to rename ModifiedBy to LastModifiedBy

ALTER TABLE dbo.Safety
DROP COLUMN ModifiedBy
ADD LastModifiedBy nvarchar(50)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.