drop column fails

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dan Ackermann (dummy_at_intos.ch)
Date: 03/01/04 

Date: Mon, 01 Mar 2004 14:19:31 +0100

Hi all,
Want to drop a column of an existing table with

alter table TE20_AREA
        drop column E20IN_NODE_NUMBER

But get:
The object 'DF__TE20_AREA__E20IN__26509D48' is dependent on column
'E20IN_NODE_NUMBER'.

What is the object DF... checked for indexes, constraints, relations
haven't found somthing with this name ????

BTW, deleting the row in the gui works like a charme ????? (Does not
help because db modification needs to be in a batch job :-( )

Any help is highly appreciated.

TIA

Dan

Relevant Pages

  • Re: Delete query taking long time to execute
    ... I have asked him to do the NOCHECK when the system is offline (No users ... constraints [See ALTER TABLE WITH NOCHECK] to make the DELETE faster. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Creating Not Null contraints in SE
    ... dbschema is failing with -100 errors. ... NOT NULL constraints cannot be 'ADDED' they have to be MODIFIED: ... ALTER TABLE xredit_cards MODIFY (somecolumn some type NOT NULL ... When you dbexport, ...
    (comp.databases.informix)
  • Re: Altering a Large Table
    ... the old one and recreate the triggers, indexes, and constraints. ... Please keep in mind that my own opinions are my own opinions and ... I'm wondering if there is a trick to altering a large table without running ... I'm running the following alter command in dbaccess; ...
    (comp.databases.informix)
  • How to check if triggers and constraints are enabled/disabled?
    ... I can disable and enable triggers and constraints with sql-statements shown ... ALTER TABLE mytable NOCHECK CONSTRAINT ALL ... How can I check if triggers and constraints are enabled or disabled? ...
    (microsoft.public.sqlserver.programming)