CODEWITHSUNDEEP
sql-server-2008
Govind
Govind

Reputation: 15

find modified and new added columns list from particular table In sql server 2008?

How to find modified and new added columns list from particular table In SQL Server 2008 ?

I am working with database and need to know list of tables which are modified.

Upvotes: 0

Views: 9046

Answers (1)

Raf
Raf

Reputation: 570

You can get modified and created columns by querying sql server metadata views:

 SELECT
    OBJECT_NAME(sc.[object_id]) as [table]
    ,sc.[name] as [column]
    ,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

Upvotes: 2

Related Questions