S’applique à :SQL Server Supprime l'historique des évaluations de stratégies en fonction du paramètre d'intervalle de rétention de l'historique. Conventions de la syntaxe Transact-SQL Syntaxe syntaxsql sp_
syntaxsql sp_purge_jobhistory[ [ @job_name= ]N'job_name'] [ , [ @job_id= ]'job_id'] [ , [ @oldest_date= ]oldest_date] [ ; ] 引數 [ @job_name = ] N'job_name' 這是要刪除記錄的作業名稱。@job_name為sysname,預設值為NULL。必須指定@job_id或@job_name,但無法指定兩者。
Syntax purge::= Description of the illustration purge.eps Semantics TABLE or INDEX Specify the name of the table or index in the recycle bin that you want to purge. You can specify either the original user-specified name or the system-generated name Oracle Database assigned to the object whe...
Syntax Arguments Return code values Remarks แสดง 3 เพิ่มเติม Applies to:SQL Server Deletes the policy health states in Policy-Based Management. Policy health states are visual indicators within Object Explorer (a scroll symbol with a red...
适用范围:SQL Server 基于保留策略从管理数据仓库中删除数据。 此过程由mdw_purge_data与指定实例关联的管理数据仓库执行SQL Server 代理作业每日执行。 可以使用此存储过程从管理数据仓库中执行数据的按需删除。 Transact-SQL 语法约定 语法 syntaxsql 复制 core.sp_purge_data [ ...
PURGEcan temporarily use significant disk space. This is a meta-function. You must call meta-functions in a top-levelSELECTstatement. Behavior type Volatile Syntax SELECT PURGE() Privileges Table owner USAGE privilege on schema Examples After you delete data from a Vertica table, that data is ma...
Transact-SQL 语法约定 语法 syntaxsql sp_syspolicy_purge_history[ ; ] 参数 该存储过程没有参数。 返回代码值 0(成功)或1(失败)。 注解 必须在系统数据库的上下文msdb中运行sp_syspolicy_purge_history。 若要查看历史记录保持期间隔,可以使用以下查询: ...
876849Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-file' is deprecated and will be removed in a future release. 2023-05-10T14:54:25.876870Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a ...
PURGE_PROJECTIONcan use significant disk space while purging the data. SeePURGEfor details about purge operations. This is a meta-function. You must call meta-functions in a top-levelSELECTstatement. Behavior type Volatile Syntax PURGE_PROJECTION ( '[[database.]schema.]projection' ) ...
SQL Statements for Controlling Group Replication Prepared Statements Compound Statement Syntax Database Administration Statements Utility Statements MySQL Data Dictionary The InnoDB Storage Engine Alternative Storage Engines Replication Group Replication MySQL Shell Using MySQL as a Document Store...