Reputation: 50
How to drop a Particular column in a Table?
Upvotes: 0
Views: 46
Reputation: 171569
CREATE TABLE dbo.MyTable (column_a INT, column_b VARCHAR(20) NULL);
GO
ALTER TABLE dbo.MyTable DROP COLUMN column_b;
GO
EXEC sp_help MyTable;
GO
DROP TABLE dbo.MyTable;
GO
Upvotes: 4