Sql-server – ny way to find out if any alteration is done to any table

sql server

I am using SQL Server and a database has too many tables. I am preparing the list of tables which have been recently modified.

Is there any way to find out which tables are modified?

I am interested in knowing:

  • if any datatypes are modified to any columns,
  • new column is added,
  • any column is deleted.

Note
The answers below shows tables which has been modified but do not give enough information of what changes has been done to the tables.

Best Answer

If you have not recently restarted your server, the default trace may have some info. In SSMS go to your DB, right click select reports -> Standard Reports -> "Schema Changes History", that should give you the changes on the DB, as long as there's info on your default trace.