sql server - How to remove a column from an existing table?

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

How to remove a column from an existing table?

I have a table MEN with Fname and Lname

I need to remove the Lname

How to do it?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

332 views

1 Answer

深蓝 · Answer 1 · 2021-10-23T18:26:56+0000

answered Oct 24, 2021 by 深蓝 (71.8m points)

ALTER TABLE MEN DROP COLUMN Lname

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…