You can delete column from table in SQL in different ways. The most popular of them are:
- Table-designer of SQL Server Management studio.
- ALTER TABLE statement.
In addition to the above methods, we are going to explore the following use cases:
- Drop the column that has a foreign key constraint.
- Drop the column that has a unique constraint.