Some times we need to remove the unwanted column from a database table completely. It can be done in two ways, either from design, directly select the column and delete or by using script. The best way to do this is by removing the column by writing an SQL Script as mentioned below.
ALTER TABLE dbo.Authors
DROP COLUMN AuthorID
Above script removes AuthorID column from table Author