Subject | Re: [firebird-support] REFLEXIVE FOREIGN KEY |
---|---|
Author | Alexandre Benson Smith |
Post date | 2007-10-13T00:49:34Z |
incaguide wrote:
Did you tried it ?
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Is it Possible with firebird to do the following ?Yes !
>
> Having the following table :
>
> ===============
> Emplyees
> ===============
> (PK) idEmployee
> idBoss
> ===============
>
> Is this possible to do ?
>
> Alter table Employees add Constraint "FK_Employees" foreign key(idboss)
> references Employees(IdBoss)
>
Did you tried it ?
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br