Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
Transact-SQL Reference
Data Definition Language (DDL) Statements (Transact-SQL)
DROP Statements (Transact-SQL)
DROP AGGREGATE (Transact-SQL)
DROP APPLICATION ROLE (Transact-SQL)
DROP ASSEMBLY (Transact-SQL)
DROP ASYMMETRIC KEY (Transact-SQL)
DROP BROKER PRIORITY (Transact-SQL)
DROP CERTIFICATE (Transact-SQL)
DROP CONTRACT (Transact-SQL)
DROP CREDENTIAL (Transact-SQL)
DROP CRYPTOGRAPHIC PROVIDER (Transact-SQL)
DROP DATABASE (Transact-SQL)
DROP DATABASE AUDIT SPECIFICATION (Transact-SQL)
DROP DATABASE ENCRYPTION KEY (Transact-SQL)
DROP DEFAULT (Transact-SQL)
DROP ENDPOINT (Transact-SQL)
DROP EVENT NOTIFICATION (Transact-SQL)
DROP EVENT SESSION (Transact-SQL)
DROP FULLTEXT CATALOG (Transact-SQL)
DROP FULLTEXT INDEX (Transact-SQL)
DROP FULLTEXT STOPLIST (Transact-SQL)
DROP FUNCTION (Transact-SQL)
DROP INDEX (Transact-SQL)
DROP LOGIN (Transact-SQL)
DROP MASTER KEY (Transact-SQL)
DROP MESSAGE TYPE (Transact-SQL)
DROP PARTITION FUNCTION (Transact-SQL)
DROP PARTITION SCHEME (Transact-SQL)
DROP PROCEDURE (Transact-SQL)
DROP QUEUE (Transact-SQL)
DROP REMOTE SERVICE BINDING (Transact-SQL)
DROP RESOURCE POOL (Transact-SQL)
DROP ROLE (Transact-SQL)
DROP ROUTE (Transact-SQL)
DROP RULE (Transact-SQL)
DROP SCHEMA (Transact-SQL)
DROP SERVER AUDIT (Transact-SQL)
DROP SERVER AUDIT SPECIFICATION (Transact-SQL)
DROP SERVICE (Transact-SQL)
DROP SIGNATURE (Transact-SQL)
DROP STATISTICS (Transact-SQL)
DROP SYMMETRIC KEY (Transact-SQL)
DROP SYNONYM (Transact-SQL)
DROP TABLE (Transact-SQL)
DROP TRIGGER (Transact-SQL)
DROP TYPE (Transact-SQL)
DROP USER (Transact-SQL)
DROP VIEW (Transact-SQL)
DROP WORKLOAD GROUP (Transact-SQL)
DROP XML SCHEMA COLLECTION (Transact-SQL)
Expand Minimize
This topic has not yet been rated - Rate this topic

DROP SIGNATURE (Transact-SQL)

SQL Server 2008 R2

Drops a digital signature from a stored procedure, function, trigger, or assembly.

Topic link icon Transact-SQL Syntax Conventions

Copy 

DROP [ COUNTER ] SIGNATURE FROM module_name 
    BY <crypto_list> [ ,...n ]

<crypto_list> ::=
    CERTIFICATE cert_name
    | ASYMMETRIC KEY Asym_key_name
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.

Information about signatures is visible in the sys.crypt_properties catalog view.

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.

The following example removes the signature of certificate HumanResourcesDP from the stored procedure HumanResources.uspUpdateEmployeeLogin.

Copy 
USE AdventureWorks2008R2;
DROP SIGNATURE FROM HumanResources.uspUpdateEmployeeLogin 
    BY CERTIFICATE HumanResourcesDP;
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.