Add Column to Table Using SQL

6/26/2017 6:22:18 PM

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