sys.periods (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row for each table for which periods have been defined.

Column header Data type Description
period_type sysname Name of the period
period_type_desc tinyint The numeric value representing the type of period:

1 = system-time period
object_id nvarchar(60) The text description of the type of column:

object_id int The id of the table containing the period_type column
start_column_id int The id of the column that defines the lower period boundary
end_column_id int The id of the column that defines the upper period boundary


The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

System Views (Transact-SQL)
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
sys.all_columns (Transact-SQL)
sys.system_columns (Transact-SQL)
Querying the SQL Server System Catalog FAQ
Temporal Tables