SQL Server 2016: Drop table operation failed on table because it is not supported operation on system-versioned temporal tables

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In the previous post, I shared basic about SQL Server 2016 System-versioned temporal tables and how you can create it.

In the previous post, I created a tbl_Studetns table and now for testing, I am going to drop it here.

But unfortunately, I got the below error.

The reason is, it is a system-versioned table and its dependent object is tbl_StudentsHistory table.

The solution is to disable system-versioned on that table by executing following statement.

Now, you can drop the tbl_Students table.

Please note:
We disabled the System-versioned so it will not drop a tbl_StudentsHistory table. If you want to tbl_StudentsHistory, you can use drop command to drop it.