Previous Topic

Next Topic

Inhoudsopgave

Book Index

Cross Database Foreign Keys

ASE support cross database foreign keys, MS SQL Server does not.

Example

alter table T2

add constraint FK_T2_Test

foreign key (i)

references IsahDevelopTest45DB.dbo.Test (i)

Note: In MS SQL Server a delete trigger on the parent table and insert and update triggers on the child table should be used instead.