Alter the table to add a new Column

Syntax

GO
ALTER TABLE [InphoDBS].dbo.USER_MASTER ADD [LAST_NAME] [nvarchar](50) NULL;

Note: While altering the table to add a Column the Column does not use NOT NULL property. Only NULL property can be used as we are altering the table.