Hi!=0AMy name is Valentin and I am writing to you for the following problem=
:=0AI created a database containing the table:=0A=A0=0ACREATE TABLE `docume=
nts_ex` (=0A=A0 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,=0A=A0 `Journ=
al_ex_ID` int(10) unsigned DEFAULT NULL,=0A=A0 `Documents_ID` int(10) unsig=
ned DEFAULT NULL,=0A=A0 `Data` datetime DEFAULT NULL,=0A=A0 `Nr` varchar(50=
) DEFAULT NULL,=0A=A0 PRIMARY KEY (`ID`),=0A=A0 UNIQUE KEY `Journal_ex_ID` =
(`Journal_ex_ID`,`Documents_ID`,`Data`,`Nr`),=0A=A0 KEY `Documents_ID` (`Do=
cuments_ID`),=0A=A0 CONSTRAINT `documents_ex_ibfk_1` FOREIGN KEY (`Journal_=
ex_ID`) REFERENCES `journal_ex` (`ID`) ON DELETE CASCADE,=0A=A0 CONSTRAINT =
`documents_ex_ibfk_2` FOREIGN KEY (`Documents_ID`) REFERENCES `documents` (=
`ID`) ON DELETE CASCADE=0A) ENGINE=3DInnoDB DEFAULT CHARSET=3Dlatin1=0A=A0=
=0AAfter some time I decided to drop 'Journal_ex_ID' column and all its env=
ironment from this non empty table.=0AAll I tried to do like:=0A=A0=0Aalter=
table documents_ex drop column Journal_ex_ID=0Aor=0Aalter table documents_=
ex drop foreign key=A0 Journal_ex_ID=0Aor =0Aalter table documents_ex drop=
=A0 key=A0 Journal_ex_ID=0A=A0=0A=A0I receive the same error 150 and I don'=
t know what to do.=0A=A0=0APlease help me.=0A=A0Best regards.=0A=0A=0A =
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2 [at] m.gmane.o rg
