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

6 Answers
9455 Views
Teledata, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the concepts and capabilities of sql server?

922

What is trace flag in sql server?

975

Explain difference between cross join and full outer join?

952

What is an expression in ms sql server?

1008

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

973

Explain what are the restrictions that views have to follow? : SQL Server Architecture

989

Can you explain powershell included in sql server 2008?

890

Will count(column) include columns with null values in its count?

1032

Explain the dirty pages?

946

What does the on update no action do?

961

what's the difference between delete table and truncate table commands? : Sql server database administration

919

What is federation member?

114

What are transactions in sql?

985

How to encrypt Strored Procedure in SQL SERVER?

1096

How to create an inline table-valued function?

906