Stored procedure to remove the foreign key 'sourceid'

Support - Assistance technique
1

Hello all,

I have written down a stored procedure to remove all of the foreign keys which is being referenced into Source (sourceid).

Hope this useful for who still getting the trouble in source id reference.

P.S: This is used for MySQL.

Remove_FK_SourceId_Script.sql (1.15 KB)

···

–
Good heath !

2

This is nice!!!

But it would be good if add a parameter for to select the DHIS
database. Anyway for MySQL people they can understand where to
correct.

Thanks
Caveman

···

On 7/1/11, Hieu Dang Duy <hieu.hispvietnam@gmail.com> wrote:

Hello all,

I have written down a stored procedure to remove all of the foreign keys
which is being referenced into Source (sourceid).

Hope this useful for who still getting the trouble in source id reference.

P.S: This is used for MySQL.

--
Good heath !