Cryptographic functions (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

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)