Answers for "Drop column operation failed on table 'RISK_G4S_LOCAL.Events.BoloReportsHistory' because it is not a supported operation on system-versioned temporal tables."

SQL
1

t-sql disable system versioning

-- REF: https://docs.microsoft.com/en-us/sql/relational-databases/tables/stopping-system-versioning-on-a-system-versioned-temporal-table?view=sql-server-ver15
ALTER TABLE [TABLE_NAME]
 SET(SYSTEM_VERSIONING = OFF)
GO
Posted by: Guest on April-11-2020

Code answers related to "Drop column operation failed on table 'RISK_G4S_LOCAL.Events.BoloReportsHistory' because it is not a supported operation on system-versioned temporal tables."

Code answers related to "SQL"

Browse Popular Code Answers by Language