Select from following answers:- No
- Yes
- Yes, if SYSTEM_VERSIONING is disabled and versioning columns are dropped from table
- All Above
To drop a Temporal Table, we need to follow below steps:
ALTER TABLE dbo.TableName SET (SYSTEM_VERSIONING = OFF)
GO
ALTER TABLE dbo.TableName
DROP PERIOD FOR SYSTEM_TIME
GO
DROP TABLE dbo.TableName
DROP TABLE dbo.TableNameHistory
Show Correct Answer
|
Alert Moderator