To Drop a Temporal Table you first need to turn System_Versioning OFF. Then Delete your required temporal table. Finally you can also choose to delete History table associated with your Temporal Table.
ALTER TABLE [dbo].[TemporalTest] SET ( SYSTEM_VERSIONING = OFF )
DROP TABLE [dbo].[TemporalTest]
DROP TABLE [dbo].[TemporalTestHistory]
If you get this sort of error as shown below:
Msg 911, Level 16, State 1, Line 1 Database 'Advantureworks ' does not exist. Make sure that the name is entered correctly.
And you already have this database, make sure you are typing the Database name correctly such as:
No difference! rowversion is new name for timestamp or we can say a synonym for timestamp datatype. Actually, the “Timestamp” datatype was defined as a counter of database row updates. Later, the ISO defined the “Timestamp” datatype as date and time information, causing a conflict between the SQL standards definition and the specific usage by MS SQL-Server. So Microsoft replaced the name “timestamp” by a new name “rowversion” Read the rest of this entry »