Subject | Re: [ib-support] Cascading Updates and Deletes? |
---|---|
Author | Andy Goodchild |
Post date | 2002-11-06T15:03:33Z |
Hello dvanatta,
Wednesday, November 6, 2002, 2:51:36 PM, you wrote:
d> Does Firebird have Cascade Update Releated Fields and Cascade Delete
d> Related Fields like MS SQL Server?
I am not an SQL Sever guy but if you are asking does Interbase have
cascading referential integrity yes it does.
If you look in the LANGUAGE reference and look at the definition of
FOREIGN KEYS you should get what you are after. As a word of caution
if you are new to Interbase please note that when you do define a
Foreign key it is much better to give the KEY a name rather than
allowing Interbase to assign default names. If you ever need to drop
the index in the future you will find it a lot easier.
--
Best regards,
Andy mailto:andy@...
Wednesday, November 6, 2002, 2:51:36 PM, you wrote:
d> Does Firebird have Cascade Update Releated Fields and Cascade Delete
d> Related Fields like MS SQL Server?
I am not an SQL Sever guy but if you are asking does Interbase have
cascading referential integrity yes it does.
If you look in the LANGUAGE reference and look at the definition of
FOREIGN KEYS you should get what you are after. As a word of caution
if you are new to Interbase please note that when you do define a
Foreign key it is much better to give the KEY a name rather than
allowing Interbase to assign default names. If you ever need to drop
the index in the future you will find it a lot easier.
--
Best regards,
Andy mailto:andy@...