• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

how can i drop this column in a table

During design time ,by mistake i wrote a column name "PromoFont",but actual the column name should "PromoFront". but when i want to drop that column in the table , I have received error message ...

Alter table Product
Drop Column PromoFont

Error message.
-----------------------------------------------
Msg 5074, Level 16, State 1, Line 1
The object 'DF__Product__PromoFo__0DAF0CB0' is dependent on column 'PromoFont'.
Msg 4922, Level 16, State 9, Line 1
ALTER TABLE DROP COLUMN PromoFont failed because one or more objects access this column.
------------------------------------------------

how can i drop this column.
0
Tapan Pattanaik
Asked:
Tapan Pattanaik
1 Solution
 
Dale BurrellCommented:
alter table Product drop constraint DF__Product__PromoFo__0DAF0CB0
go
alter table Product drop column PromoFont
go
0
 
Tapan PattanaikSenior EngineerAuthor Commented:
Many Many Thanks and Correct answer.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now