Cryptographic functions (Transact-SQL)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database

These functions support digital signing, digital signature validation, encryption, and decryption.

Symmetric encryption and decryption

 

Asymmetric encryption and decryption

 

Signing and signature verification

 

Symmetric decryption, with automatic key handling

 

Encryption hashing

 

Certificate copying

 

See also

Functions
Encryption Hierarchy
Permissions Hierarchy (Database Engine)
CREATE CERTIFICATE (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
Security Catalog Views (Transact-SQL)