[firebase-br] Ocultar o código de triggers ou procedures

[Fernando Alécio]

On 17/03/2015 15:38, Jéter Rabelo - GMail wrote:
> update RDB$PROCEDURES
> set RDB$PROCEDURE_SOURCE = null,
>      RDB$DESCRIPTION = 'Protegido por lei de copyright'
> where ((RDB$SYSTEM_FLAG = 0) or (RDB$SYSTEM_FLAG is null));
> update RDB$TRIGGERS A
> set RDB$TRIGGER_SOURCE = null,
>      RDB$DESCRIPTION = 'Protegido por lei de copyright'
> where ((RDB$SYSTEM_FLAG = 0) or (RDB$SYSTEM_FLAG is null)) and
>        not exists(select RDB$TRIGGER_NAME
>                   from RDB$CHECK_CONSTRAINTS
>                   where RDB$TRIGGER_NAME = A.RDB$TRIGGER_NAME);
> update RDB$RELATIONS
> set RDB$VIEW_SOURCE = null,
>      RDB$DESCRIPTION = 'Protegido por lei de copyright'
> where ((RDB$SYSTEM_FLAG = 0) or (RDB$SYSTEM_FLAG is null));
>
> commit work;
>
> Jeter-Jerasoft

Bom dia Jeter e obrigado pela resposta.

T++++++++++

---
Este email foi escaneado pelo Avast antivírus.
http://www.avast.com