The culumn from_core was created by a program that execute this code:
ALTER TABLE WebRsLog ADD [from_core][bit] NOT NULL DEFAULT 1
Now I need to drop this column. Using the code:
ALTER TABLE WebRsLog DROP COLUMN [from_core]
I get the error:
The object 'DF__WebRsLog__from_c__7C86175C' is dependent on column 'from_core'.
So, I need to drop the constraint first. A problem - the name of the constraint was created automaticly and is not known. Tried looking into the system tables without success. How can I find the constraint name or id when the only known data is the table name and the column name.
Avron Tal