1

Is there a SQL query which can fetch the list of all Temporal Table from Teradata Database?

Is there any special Column for Temporal Tables which identifies them of which type of Temporal Table it is?

1 Answers1

2

There is a TemporalProperty column in dbc.tablesv.

SELECT * FROM dbc.TablesV WHERE TemporalProperty <> 'N'

TemporalProperty values (thanks @Dnoeth):

V: ValidTime
T: TransactionTime
B: BiTemporal
N: Not Temporal
Andrew
  • 8,445
  • 3
  • 28
  • 46