Velmurugan
Velmurugan

Reputation: 50

Query in SQL2000

How to drop a Particular column in a Table?

Upvotes: 0

Views: 46

Answers (1)

D'Arcy Rittich
D'Arcy Rittich

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

Related Questions