Delete Specific Column From an Table – Azure Data Studio

Removing Specific Column from Azure Data Studio Table.

Syntax : –

-- Drop '[ColumnName]' from table '[TableName]' in schema '[dbo]'
ALTER TABLE [dbo].[TableName]
    DROP COLUMN [ColumnName]
GO
Removing MGR Column. (Query)
-- Drop '[MGR]' from table '[EMP]' in schema '[dbo]'
ALTER TABLE [dbo].[EMP]
    DROP COLUMN [MGR]
GO

Output : -

Post Author: adama