How to Drop a Column in SQL Server in SQL Server

Dropping a column in SQL Server involves using the ALTER TABLE .. DROP COLUMN command.

Drop one column:

alter table products
drop column description;

Drop multiple colums at the same time:

alter table products
drop column price, description;
Cta

Shared queries and folders ✅ Version history ✅ One-click connection to SQL Server ✅

Get more done, together, with PopSQL and SQL Server