databasealterations.sql

来自「微软的行业应用解决方案示例」· SQL 代码 · 共 41 行

use hardwaredistributor
go

-- switch on change tracking for the database
	ALTER DATABASE hardwaredistributor
	SET CHANGE_TRACKING = ON
	(CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)

-- enable tracking on all tables
	ALTER TABLE Customers
	ENABLE CHANGE_TRACKING

	ALTER TABLE DistributionCenters
	ENABLE CHANGE_TRACKING

	ALTER TABLE Employees
	ENABLE CHANGE_TRACKING

	ALTER TABLE Inventory
	ENABLE CHANGE_TRACKING

	ALTER TABLE OrderDetails
	ENABLE CHANGE_TRACKING

	ALTER TABLE Orders
	ENABLE CHANGE_TRACKING

	ALTER TABLE OrderState
	ENABLE CHANGE_TRACKING

	ALTER TABLE Roles
	ENABLE CHANGE_TRACKING

	ALTER TABLE Routes
	ENABLE CHANGE_TRACKING

	ALTER TABLE Trucks
	ENABLE CHANGE_TRACKING

--create stored procedures to get