Determine Last Modification Datetime for an Azure Table
- by embeddedprogrammer
I am developing an application which may be hosted on a microsoft sql server, or on Azure SQL, depending upon the end user's wishes.
My whole system works fine with the exception of some WCF functions which determine the last modification time of tables using the following technique:
SELECT OBJECT_NAME(OBJECT_ID) as tableName,
last_user_update as lastUpdate
FROM mydb.sys.dm_db_index_usage_stats
This query fails in Azure. Is there any analogous way to get table last modification dates from Azure's sql?