How to capture - Schema changes ?

Hi there,

I have a requirement to capture all the schema changes i.e Alter table (add/delete/modify) tables or columns. I was hoping to use CDC but seems not fit for this purpose.

Is there a better way to achieve the above requirement or can I use CDC itself?. The captured change should give table_name, column, change etc… like metadata.

Please advice,