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)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for