row versioning in sql server
Drop system-versioned temporal table in SQL Server
To Drop a Temporal Table you first need to turn System_Versioning OFF. Then Delete your required temporal table. Finally you can also choose to delete History table associated with your Temporal Table.
ALTER TABLE [dbo].[TemporalTest] SET ( SYSTEM_VERSIONING = OFF )
DROP TABLE [dbo].[TemporalTest]
DROP TABLE [dbo].[TemporalTestHistory]