bigator

When my SQL table was updated???

Here is very tiny SQL query which will help you find out when the tables are modified in the SQL server database. First you try the * (get all the columns) and then choose the selected ones.

— List all the tables updated in SQL Server (in desc order)
Use your Database Name
Select * from sys.tables order by Modify_date desc

Like wise, you can also check few more readymade tables which store some helpful information for you.

dbo.sysdiagrams
sys.tables
sys.all_columns
sys.objects
sys.foreign_key_columns
sys.data_spaces

I hope you will find this helpful. Thanks 🙂

bigatorJanuary 27, 2012 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: ,  · Posted in: General, Interview QA, Quick Tips, SQL Server, Suggestion, T-SQL

One Response

  1. clarke - February 27, 2012

    Ohh, thanks. Simple & life saver.
    Clarke

Leave a Reply


%d bloggers like this:
bigator