Deleting Columns From a Table with a Query in MS SQL
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]