how can i drop this column in a table

Posted on 2011-04-21
Last Modified: 2012-06-27
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.
Question by:Tapan Pattanaik
    LVL 21

    Accepted Solution

    alter table Product drop constraint DF__Product__PromoFo__0DAF0CB0
    alter table Product drop column PromoFont
    LVL 20

    Author Closing Comment

    by:Tapan Pattanaik
    Many Many Thanks and Correct answer.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now