Is there any way to get metadata (information scheme) information about temporal table feature for the table, like:
- Is DATA_CONSISTENCY_CHECK TURNED ON OR OFF
- What name of history table
- Is SYSTEM_VERSIONING turned for the table
information-schemametadatasql-server-2016temporal-tables
Is there any way to get metadata (information scheme) information about temporal table feature for the table, like:
Best Answer
This is a one time operation when the table is created. This will not appear anywhere in the database because it is a one time operation.
You can see this yourself:
Likewise, you can perform this check after the creation of the table too:
MSDN on DBCC CHECKCONSTRAINTS
MSDN Source
You can use this query to find the history tables:
If you query around sys.tables, you will find a lot of handy information.
Source: MS SQL Tips by Ameena Lalani