# 3730 Trying to Drop a Column with References to Itself Causes Dependency Error

---

In table MyTable I have a column called CompanyId that is a GUID and its default is set to:

Default:
IFNULL(CompanyId,fcn_GetActiveCompanyId(),CompanyId);

Basically this default value will update CompanyId with the active company id (set in another table) when the MyTable row is added. (Yes, I could have used a trigger for this, but I wanted this value defined prior to the post event in Delphi).

If I later decide to use EDBMgr to drop the column CompanyId from table MyTable, it complains CompanyId is referenced by CompanyId.

Here is the error message:
ElevateDb Error #201 The column CompanyId in the table MyTable cannot be dropped because it is still referenced by the column CompanyId in the table MyTable.

So when dropping an object like a column, EDB should ignore any references that point to itself.