Sql

Search

t-sql disable system versioning

-- REF: https://docs.microsoft.com/en-us/sql/relational-databases/tables/stopping-system-versioning-on-a-system-versioned-temporal-table?view=sql-server-ver15
ALTER TABLE [TABLE_NAME]
 SET(SYSTEM_VERSIONING = OFF)
GO

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql find missing values between two tables
Sql :: reset auto increment in sql
Sql :: postgresql create table with index
Sql :: hibernate dialect property xml for mysql 8
Sql :: select item.* as json mysql
Sql :: mssql remove column
Sql :: mysql strict_trans_tables
Sql :: sql sum if
Sql :: create table mysql query
Sql :: ordering by issue with 4 digit numbers in sql
Sql :: mysql id of inserted row
Sql :: sql remanecolumn
Sql :: mysql subtract month from timestamp
Sql :: oracle list datafiles in tablespace
Sql :: add primary key to existing table sql
Sql :: DUPLICATE column values
Sql :: update substring in mysql
Sql :: import sql file in mysql
Sql :: how to delete duplicate rows in oracle
Sql :: uninstall mysql server ubuntu
Sql :: oracle limit user tablespace
Sql :: mysql order by desc limit
Sql :: Sql creating roles
Sql :: reset auto increment in mysql
Sql :: get table column names sql laravel
Sql :: mysql select last row for each group
Sql :: compare date in sql
Sql :: oracle grants
Sql :: centos 8 install mysql
Sql :: org.h2.jdbc.JdbcSQLSyntaxErrorException

Search

SQL

t-sql disable system versioning

ADD CONTENT