Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

SET TEMPORAL_HISTORY_RETENTION ON

Hi Redgate Team,

It seems that there is not SQL Prompt support for

-- Enbable retention policy for a temporal tables
ALTER DATABASE AdventureWorks2017 SET TEMPORAL_HISTORY_RETENTION ON;
GO

TEMPORAL_HISTORY_RETENTION will not be suggested...

Would be great if you can add this- thanks!

Torsten



Answers

Sign In or Register to comment.