Select from following answers:- TRUNCATE operation is not supported on the TEMPORAL table
- TRUNCATE operation is supported on the TEMPORAL table
- None
- All Above
If you try to truncate a temporal table, SQL throws below exception
Msg 13545, Level 16, State 1, Line 1
Truncate failed on table ‘DBName.dbo.TableName’ because it is not supported operation on system-versioned tables.
Show Correct Answer
|
Alert Moderator