Managing DDL changes

Isabelle_VelaIsabelle_Vela ✭
in General Discussion

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

Comments

  • emorenoemoreno Employee

    In the query profiles table you have query_type that tells if it is a DDL what was executed. However, this data is phase out depending on your data collector setting. You could capture the info in a physical table and keep track if you need it.

    Hope this helps.
    Eugenia

  • zvika_gutkinzvika_gutkin

    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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...