In design mode we usually design more. But in implementation time we need to remove/delete/drop some additional columns. Here in this article I will show you the syntax of Deleting a Column of a SQL Server.
SQL Syntax to Delete a Column of a SQL Server Table:
By using the DROP COLUMN clause, one can remove an existing column. This permanently deletes the column and all of its contents or data. For example, the following command drops the Notes column from the Articles table.
ALTER TABLE Articles DROP COLUMN Notes