Transact-SQL: Adding a Column to a Table

 

 

To add a new column to a table, follow this syntax:

ALTER TABLE TableName
ADD ColumnName Properties

Here is an example:

ALTER TABLE Members
ADD Address varchar(100) NULL
GO

When above code is executed, a new column named Address, of type varchar, with a limit of 100 characters, and that allows empty entries, would be added to the table named Members.

• Previous Entry: SQL Expressions/Examples
• Next Entry: An Identity Column