Cryptographic functions (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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)