其中,function_name是要删除的函数的名称。例如,要删除名为“get_customer_name”的函数,可以使用以下语句: DROP FUNCTION get_customer_name; 5. DROP TRIGGER语句 DROP TRIGGER语句用于删除一个触发器。语法如下: DROP TRIGGER trigger_name ON table_name; 其中,trigger_name是要删除的触发器的名称,table_name是...
function_name 要删除的用户定义函数的名称。可以选择是否指定架构名称。不能指定服务器名称和数据库名称。备注如果数据库中存在引用 DROP FUNCTION 的 Transact-SQL 函数或视图并且这些函数或视图通过使用 SCHEMABINDING 创建,或者存在引用该函数的计算列、CHECK 约束或 DEFAULT 约束,则 DROP FUNCTION 将失败。
A Boolean value that specifies whether the DropFunction event is included in the event set. If True, the event is included in the event set. If False (default), the event is not included in the event set. 示例 处理SMO 事件 请参阅 参考 ServerEventSet 类 Microsoft.SqlServer.Management.Sm...
DROP SERVER AUDIT DROP ASYMMETRIC KEY DROP FUNCTION DROP SERVER AUDIT SPECIFICATION DROP BROKER PRIORITY DROP INDEX DROP SERVICE DROP CERTIFICATE DROP LOGIN DROP SIGNATURE DROP CONTRACT DROP MASTER KEY DROP STATISTICS DROP CREDENTIAL DROP MESSAGE TYPE ...
Partition functions are created by using CREATE PARTITION FUNCTION and modified by using ALTER PARTITION FUNCTION.Transact-SQL syntax conventionsSyntaxsyntaxsql Copiere DROP PARTITION FUNCTION partition_function_name [ ; ] Notă To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier ...
DROPalias-designatorAUDIT POLICY原則名稱BUFFERPOOL緩衝池名稱DATABASE PARTITION GROUPdb-partition-group-nameEVENT MONITORevent-monitor-namefunction-designatorRESTRICTFUNCTION MAPPINGfunction-mapping-nameHISTOGRAM TEMPLATEtemplate-nameINDEX索引名稱1INDEX EXTENSIONindex-extension-nameRESTRICTMASKmask-namemethod-designatorRE...
EVENT MONITORFUNCTION MAPPINGfunction-mapping-name1mask-namemethod-designatorRESTRICTMODULEmodule-nameNICKNAMEnicknamePACKAGEpackage-nameVERSIONversion-idPERMISSIONpermission-nameprocedure-designatorRESTRICTROLErole-nameSCHEMAschema-nameRESTRICTSECURITY LABELsecurity-label-nameRESTRICTSECURITY LABEL COMPONENTsec-label-comp-...
Learn more about the Microsoft.SqlServer.Management.SqlParser.SqlCodeDom.SqlDropFunctionStatement in the Microsoft.SqlServer.Management.SqlParser.SqlCodeDom namespace.
topics:ALTERTABLEDEALLOCATEPREPAREDROPDATABASEDROPEVENTDROPFUNCTIONDROPFUNCTIONUDFDROPINDEXDROPPROCEDUREDROPRESOURCEGROUPDROPROLEDROPSERVERDROPSPATIAL REFERENCE SYSTEMDROPTABLEDROPTABLESPACEDROPTRIGGERDROPUSERDROPVIEWmysql>mysql> 二.DROP DATABASE DROP DATABASE语句用来删除数据库操作,即删除了数据库也删除数据库里的所有...
Partition functions are created by using CREATE PARTITION FUNCTION and modified by using ALTER PARTITION FUNCTION. Transact-SQL Syntax ConventionsSyntax Copy DROP PARTITION FUNCTION partition_function_name [ ; ] Arguments partition_function_name Is the name of the partition function that is to be ...