Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integrity in Firebird database
Message
From
18/07/2004 08:09:42
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00925252
Message ID:
00925561
Views:
16
Hi
Very simple, by creating a foreign key constraint (if you use IBExpert, Constraints tab in table designer)
alter table CHILD_TABLE
add constraint FK_CONSTR
foreign key (PK_PARENT)
references PARENT_TABLE(ID_PARENT)
on delete CASCADE
on update CASCADE
>Hello,
>
>How can I create a referencial integrity in Firebird database?
>
>Thank you very much
>
>Adionei
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform