• You should investigate DDL triggers - search on that and you will find that what you are trying to do is often given as an example of their usage.

    Screwing around with system tables is likely to make you wish you had only accidentally dropped a table.