Add Columns
2016 (13.x) and later versions
Azure
SQL Managed Instance
Analytics Platform System (PDW)
Warehouse in Microsoft Fabric
This article describes how to add new columns to a table in SQL Server by using SQL Server
Management Studio or Transact-SQL.
Using the
statement to add columns to a table automatically adds those columns
to the end of the table.
If you want the columns in a specific order in the table, you must use SQL Server Management
Studio. Though it isn’t recommended, for more information on reordering tables, see
Change
Column Order in a Table.
To query existing columns, use the
sys.columns
object catalog view.
Requires
permission on the table.
Management Studio (SSMS) doesn’t support all data definition language (DDL)
options in Azure Synapse. Use
T-SQL scripts
instead.
- In
, right-click the table to which you want to add columns and choose.
- Select the first blank cell in the
column.
- Type the column name in the cell. The column name is a required value.
）
Important
Install the latest version of
Management Studio (SSMS).
ALTER TABLE
ALTER