SQL Query to find the date when new column is added or modified in sql

1.	SQL Query to find the date when new column is added or modified in sql table?
Answer» SQL QUERY to find the date when new column is added or modified in sql table? Below is the SQL query to GET the DETAILS of when new column is added or modified:- SELECT OBJECT_NAME(sc.[object_id]) as [table_name] ,sc.[NAME] as [column_name] ,so.modify_date ,so.create_date FROM [sys].[columns] sc JOIN [sys].[objects] so ON sc.[object_id] = so.[object_id] ORDER BY so.modify_date DESC, so.create_date ASC

Discussion