select name,create_date,modify_date from sys.tables order by modify

How to find the date and time of last updated table?

Question Posted / smitha

Answer Posted / smitha

select name,create_date,modify_date from sys.tables
order by modify_date desc

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the benefits and tasks of object explorer? : sql server management studio

1178

How to create a testing table with test data in ms sql server?

1083

Explain the difference between primary keys and foreign keys?

1021

Explain about temporary stored procedure?

1016

To which devices can a backup be created and where should these devices be located? : sql server management studio

1043

Explain “row_number()” in sql server with an example?

1000

Explain cursor as data base object?

1040

explain databases and sql server databases architecture? : Sql server database administration

957

where the connection string store in the database

2069

What is tablix?

162

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

982

How to sort the query output with order by clauses in ms sql server?

1033

What is sql sandbox in sql server?

1217

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

972

How to convert numeric expression data types using the cast() function?

1064