Store Your Code Now
Tools: String Manipulations Find Dupes My IP Json Formatter Lorem Ipsum More...
Discussion Options

Add Column to Table Using SQL

6/26/2017 2:22:18 PM by: CodeLocker

SQL

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.

View Copy: Content Copied
ALTER TABLE My_Table_Name
ADD New_Column_Name NVARCHAR(MAX) NULL
Copy: Content Copied
×

Get Coding

Store your first code or add more code to your collection.
You must login to report abuse. ×