List of recently updated tables in database

I have multiple tables in my database. I need to know the names of tables updated after some timestamp (or during last action).

Can you please guide me with links for the query or any h开发者_C百科elp?

select * from sys.tables order by modify_date desc

Assuming this is SQL server.

Check this out...

SELECT
    [name],
    create_date,
    modify_date
FROM sys.tables
ORDER BY modify_date DESC

You need to maintain a TimeStamp column in every table to be able to achieve this through a query. Assuming you have such column, look here for ways to write TimeStamp based query.