Skip to main content

Managing DDL changes

  • Mar 9, 2017 2:02 PM UTC
  • 1 reply
  • 2 views

Isabelle_Vela
Forum|alt.badge.img+1

Hello
is there any tool to track the DDL changes performed on a DB (objects created, altered, dropped ... on a date) ?

If we need to create home-made queries, where can we find the altered date for a table/view/projection/sequence ...? I could find only the creation date of schemas/tables/comments and views...

Thanks
Isabelle

1 reply

zvika_gutkin
Forum|alt.badge.img
  • Participating Frequently
  • Mar 16, 2017 2:49 PM UTC

We are having repository for all v_catalog v_monitor tables but you can use the data collector table with custom retention
plus we manage our deployments using flyway