DROP SIGNATURE (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
Drops a digital signature from a stored procedure, function, trigger, or assembly.
Transact-SQL syntax conventions
Syntax
DROP [ COUNTER ] SIGNATURE FROM module_name
BY <crypto_list> [ ,...n ]
<crypto_list> ::=
CERTIFICATE cert_name
| ASYMMETRIC KEY Asym_key_name
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
module_name
Is the name of a stored procedure, function, assembly, or trigger.
CERTIFICATE cert_name
Is the name of a certificate with which the stored procedure, function, assembly, or trigger is signed.
ASYMMETRIC KEY Asym_key_name
Is the name of an asymmetric key with which the stored procedure, function, assembly, or trigger is signed.
Remarks
Information about signatures is visible in the sys.crypt_properties catalog view.
Permissions
Requires ALTER permission on the object and CONTROL permission on the certificate or asymmetric key. If an associated private key is protected by a password, the user also must have the password.
Examples
The following example removes the signature of certificate HumanResourcesDP
from the stored procedure HumanResources.uspUpdateEmployeeLogin
.
USE AdventureWorks2022;
DROP SIGNATURE FROM HumanResources.uspUpdateEmployeeLogin
BY CERTIFICATE HumanResourcesDP;
GO
See Also
sys.crypt_properties (Transact-SQL)
ADD SIGNATURE (Transact-SQL)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho