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
| |