title: Table Details in Azure Datawarehouse
body: <p>Is there any in-built query/catalog view available in <strong>Azure Data warehouse</strong> to show last updated date, last
  inserted date, last deleted date, last index scanned date of a table? I tried below query</p>
  <pre><code>SELECT
  tbl.name
  ,ius.last_user_update
  ,ius.user_updates
  ,ius.last_user_seek
  ,ius.last_user_scan
  ,ius.last_user_lookup
  ,ius.user_seeks
  ,ius.user_scans
  ,ius.user_lookups
  FROM
  sys.dm_pdw_nodes_db_index_usage_stats ius INNER JOIN
  sys.tables tbl ON (tbl.OBJECT_ID = ius.OBJECT_ID)
  WHERE ius.database_id = DB_ID()
  </code></pre>
  <p>But it is not giving output against all the tables. Any help much appreciated.</p>