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

Why are sql functions used?

773

What are the aggregate and scalar functions?

706

Tell me what is difference between clustered and non clustered index?

716

What is raid? : SQL Server Architecture

807

Define indexes?

795

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

676

Describe and explain about SQL native client?

789

What’s the distinction between dropping a info and taking a info offline?

805

Explain stored procedure?

785

What is sql server profiler?

744

What is use of dbcc commands?

787

Why we use the openxml clause?

721

What is partitioned view?

670

What stored by the master?

718

What are the ways available in sql server to execute sql statements?

777