Welcome to Sign in | Help

Re: Script stergere in cascada

  •  11-18-2009, 2:46 PM

    Re: Script stergere in cascada


    pt tabela A creezi un composite primary key
    pt Tabela B creezi un foreign key

    alter table TabelaA add primary key (PlanID, InfNo)
    alter table TabelaB add foreign key (PlanID, InfNo) references Tabelaa (PlanID, InfNo)

    apoi modifici foreign key-ul creat cu delete rule -> cascade


View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems