Can we TRUNCATE a Temporal Table?

 Posted by Bandi on 8/31/2017 | Category: Sql Server Interview questions | Views: 11948 | Points: 40
Select from following answers:
  1. TRUNCATE operation is not supported on the TEMPORAL table
  2. TRUNCATE operation is supported on the TEMPORAL table
  3. None
  4. All Above

Show Correct Answer

| Alert Moderator 

Comments or Responses

Posted by: Sunny123 on: 1/16/2018 | Points: 10
No, Truncate is not supported on TEMPORAL tables. You have to set the System Versioning to OFF and drop the versioning Columns and then Drop the History table. Then Finally You can drop the TEMPORAL table.
Posted by: Jerbrown on: 2/19/2018 | Points: 10
what is that for?

Login to post response