Tencent Cloud Notices > Notice Details
[TencentDB for SQL Server] Announcement on the Limitations for Creating, Modifying, and Migrating Risky Triggers
2026-04-29 19:03:37
Dear Tencent Cloud user,
To enhance the stability of cloud databases and the security of data migration, TencentDB for SQL Server provides an enhanced security protection trigger feature. This feature enforces strict limitation policies on specific types of triggers. Please read the following details.
Supported Triggers
In TencentDB for SQL Server, only the following triggers can be migrated, created, or modified:
CREATE_TABLE, ALTER_TABLE, DROP_TABLE
CREATE_VIEW, ALTER_VIEW, DROP_VIEW
CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE
CREATE_FUNCTION, ALTER_FUNCTION, DROP_FUNCTION
CREATE_INDEX, ALTER_INDEX, DROP_INDEX
CREATE_STATISTICS, DROP_STATISTICS, UPDATE_STATISTICS
CREATE_SYNONYM, DROP_SYNONYM
CREATE_TYPE, DROP_TYPE
DDL_TABLE_EVENTS, DDL_VIEW_EVENTS, and other DDL event groups
Other non-security-sensitive DDL events
Limitation Scope
Triggers other than the types listed above cannot be created or modified.
If a migrated file contains triggers other than those listed above, the triggers are automatically deleted after the migration is completed.
Affected Features
We apologize for any inconvenience and appreciate your trust and support for Tencent Cloud.
