Hi,
i am searching for a solution for a few hours now. I created a table in sql_ce with the follwoing query:
CREATE TABLE [Customer]
([_id] int NOT NULL IDENTITY (1,1),
[firstName] nvarchar(4000) NULL,
[lastName] nvarchar(4000) NULL,
[sex] nvarchar(4000) NULL,
[orderAddress_fk] int NULL,
[deliveryAddress_fk] int NULL,
[paymendMethod_fk] int NULL,
[emailAddress] nvarchar(4000) NULL,
[phone] nvarchar(4000) NULL,
[mobilePhone] nvarchar(4000) NULL,
[company] nvarchar(4000) NULL);
and added a foreignkeyconstraint. it was created succesfully, because i am not able to drop that table. i used the following query:
ALTER TABLE Customer
ADD CONSTRAINT orderAddress_fk
FOREIGN KEY (orderAddress_fk) REFERENCES Address(_id)
so i want to drop the constraint and tried the follwing commands:
ALTER TABLE [Customer]
ALTER COLUMN orderAddress_fk
DROP DEFAULT
ALTER TABLE [Customer]
DROP CONSTRAINT orderAddress_fk
the query executes with succes but after executing, i am still not able to drop the table, and the UI shows that the constraint still exists...
i dont know what to try else... :(