|
sp_DropReferentialIntegrity Advantage SQL Engine |
|
|
|
sp_DropReferentialIntegrity Advantage SQL Engine |
|
|
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