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 |
![]() |
#1 | |
Ivan Dilber
Sir Write-a-Lot
|
![]() 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. |
|
![]() |
![]() |
![]() |
#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. |
![]() |
![]() |
![]() |
|
|