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 data files?

665

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2174

What do you mean by an execution plan?

670

How to filter out duplications in the returning rows in ms sql server?

733

Explain rdbms?

674

How do I find sql server instance name?

606

What is ms sql server triggers?

626

what is the Ticketing tool used in Wipro technologies at Bangalore...???

7611

Explain the xml support sql server extends?

706

Explain transaction isolation levels in sql server?

639

what is raid and what are different types of raid configurations? : Sql server database administration

630

Explain mixed authentication mode of sql server?

626

Why it is recommended to avoid referencing a floating point column in the where clause?

614

What is store procedure?

752

What is coalesce in sql server?

633