Navigation:  Advantage SQL > System Procedures > Procedures >

sp_DropReferentialIntegrity

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

Removes a referential integrity (RI) constraint from the data dictionary.

Syntax

sp_DropReferentialIntegrity( Name,CHARACTER,200 )

Parameters

Name (I)

Name of the RI constraint in the data dictionary to be removed.

Remarks

sp_DropReferentialIntegrity will remove a RI constraint from the data dictionary.

The parent and child table must not be opened, so that the Advantage Database Server can temporarily open the parent and the child tables exclusively. This function will temporarily open all tables exclusively that are in the data dictionary and that interlink with these tables through other RI constraints

Example

EXECUTE PROCEDURE sp_DropReferentialIntegrity( ‘salesreps_has_office’ );

See Also

system.relations

sp_CreateReferentialIntegrity