Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186

    Unanswered: store changes in tables to a temporary table

    Hi,
    Is there any way to create a trigger on system tables?
    I would like to store changes in my tables (like column added or dropped or modified) in a temporary table.

    Please suggest,
    Prashant

  2. #2
    Join Date
    Jun 2002
    Location
    UK
    Posts
    525
    I have a Unix script (attached) that is run every night to compare object definitions from the previous run. I can't guarantee that there aren't abny bugs in it but it's worked satisfactorily for a few months now.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •