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 create an inline table-valued function?

1023

What is attribute? : sql server analysis services, ssas

1069

What are the types of lock supported by ?

1093

What is the contrast between sql and mysql?

1158

How to see existing views in ms sql server?

1110

What is difference between clustered index and non clustered index?

1125

How to enter binary string literals in ms sql server?

1213

How to search for a string in all stored procedure in sql server?

1055

What is user defined datatypes and when you should go for them?

1068

Difference between connected and disconnected database in .net with sql server?

1150

what do you understand by change data capture?

1078

Can select statements be used on views in ms sql server?

1113

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2076

What do you mean by an execution plan?

1188

How to loop through result set objects using mssql_fetch_array()?

1136