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

Related content

• What are the SQL database 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)