If we want to delete a column from a table with a query in MS SQL Server, we follow the path below.

ALTER TABLE {Table Name} DROP COLUMN {Column Name}

Example usage would be as follows..

ALTER TABLE [dbo].[Blogs] DROP COLUMN [Url]