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

How to use go command in "sqlcmd"?

1207

How to Update from select query in sql server?

1061

How to connect php with different port numbers?

1087

what's sql server? : Sql server database administration

1000

How to verify a login name with sqlcmd tool?

1221

How to grant a permission in ms sql server using "grant execute" statements?

1094

How do you delete a trigger?

981

what is denormalization and when would you go for it? : Sql server database administration

1189

What are the disadvantages of primary key and foreign key in SQL?

1116

How can you stop stored procedures from recompiling?

900

Explain acid?

1083

What is a mixed extent?

1025

Which are new data types introduced in sql server 2008?

1049

Describe in brief databases and sql server databases architecture.

1011

What is normalization of database?

1105