SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
|
Alati teme | Način prikaza |
03. 05. 2011. | #1 | |
Ivan Dilber
Sir Write-a-Lot
|
Kako dropovati FK na mysql-u?
Imam FK definiciju:
Kôd:
CONSTRAINT `pozivi_ibfk_3` FOREIGN KEY (`agencije_id`) REFERENCES `agencije` (`id`), Kôd:
alter table pozivi drop key agencije_id; Citat:
__________________
Leadership is the art of getting people to want to do what you know must be done. |
|
03. 05. 2011. | #2 |
Ivan Dilber
Sir Write-a-Lot
|
Ok, shvatio, prava sintaxa je:
Kôd:
alter table pozivi drop foreign key pozivi_ibfk_3;
__________________
Leadership is the art of getting people to want to do what you know must be done. |
|
|