title: How to determine if sql table is Temporal?
body: <p>With SQL Server 2016 supporting <a href="https://msdn.microsoft.com/en-us/library/dn935015.aspx" rel="noreferrer" title="Temporal Tables">Temporal Tables</a> I wonder if there is a way to determine if a table is currently temporal? Something like</p>
  
  <p><code>select * from sys.objects where object_id('dbo.MyTable', 'u') = parent_object_id and type_desc = "SYSTEM_VERSIONED"</code></p>