Add a new column to a SQL Server table using just SQL. You will need to replace NVARCHAR(MAX) with the needed data type and NULL with NOT NULL if NOT NULL is required.
ALTER TABLE My_Table_Name
ADD New_Column_Name NVARCHAR(MAX) NULL
Add a new column to a SQL Server table using just SQL. You will need to replace NVARCHAR(MAX) with the needed data type and NULL with NOT NULL if NOT NULL is required.
ALTER TABLE My_Table_Name
ADD New_Column_Name NVARCHAR(MAX) NULL