dbc_AfterDropTable Event

Occurs after a table is removed from database and deleted from disk by the DROP TABLE command.

PROCEDURE dbc_AfterDropTable(cTableName, lRecycle) 

-Or-

PROCEDURE dbc_AfterDropTable
LPARAMETERS cTableName, lRecycle

Parameters

  • cTableName
    Specifies the table removed from the current database and deleted from disk.
  • lRecycle
    Specifies whether the table was placed in the Windows Recycle Bin rather than immediately deleted from the disk.

Remarks

You can use the dbc_AfterDropTable event to verify an appropriate value for cTableName, use those parameters in a procedure to track, or manage access to the database after a table is removed from the database and from the disk.

If you delete a table by using DELETE FILE or the operating system, no event occurs.

Example

* Reports to the screen the event name, where it is called from, and
* the parameter values passed to it.
PROCEDURE dbc_AfterDropTable ;
         (cTableName, ;
          lRecycle)
? '>>   ' + PROGRAM()
?? ' in ' + SUBSTR(SYS(16),RAT('\',SYS(16))+1)
? '     cTableName = ' + TRANSFORM(cTableName) + ' - ' ;
                   + TYPE('cTableName ')
? '     lRecycle   = ' + TRANSFORM(lRecycle)   + ' - ' ;
                   + TYPE('lRecycle')+' /end/ '
ENDPROC

See Also

Enable or Disable DBC Events | dbc_BeforeDropTable Event