Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
Azure Data Studio is retiring on February 28, 2026. We recommend that you use Visual Studio Code. For more information about migrating to Visual Studio Code, visit What's happening to Azure Data Studio?
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
System-versioned tables, also known as temporal tables, can also be configured directly on Azure Data Studio. If you're new to system versioning, check out the temporal tables on SQL Server documentation. System-versioning tables must have the period columns defined.
Create a system-versioned table
Create a table called "Department" with the column properties as seen below. To do this, right-click on the Tables folder in the Connections pane and select "New Table." Next, in the Table Properties pane, select the "System Versioning Enabled" check box. You can decide to rename this history table or leave the default name as is.
The period columns, ValidFrom, and ValidTo are enabled by default on system-versioned tables. The script pane will now be updated to show the T-SQL version of this system-versioned table.
Note
System-versioned tables require a primary key.