暗号化関数 (Transact-SQL)Cryptographic functions (Transact-SQL)

適用対象: ○SQL Server ○Azure SQL Database XAzure SQL Data Warehouse XParallel Data WarehouseAPPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

これらの関数は、デジタル署名、デジタル署名の検証、暗号化、および暗号化解除をサポートします。These functions support digital signing, digital signature validation, encryption, and decryption.

対称暗号化および対称暗号化解除Symmetric encryption and decryption

ENCRYPTBYKEYENCRYPTBYKEY DECRYPTBYKEYDECRYPTBYKEY
ENCRYPTBYPASSPHRASEENCRYPTBYPASSPHRASE DECRYPTBYPASSPHRASEDECRYPTBYPASSPHRASE
KEY_IDKEY_ID KEY_GUIDKEY_GUID
DECRYPTBYKEYAUTOASYMKEYDECRYPTBYKEYAUTOASYMKEY KEY_NAMEKEY_NAME
SYMKEYPROPERTYSYMKEYPROPERTY

非対称暗号化および非対称暗号化解除Asymmetric encryption and decryption

ENCRYPTBYASYMKEYENCRYPTBYASYMKEY DECRYPTBYASYMKEYDECRYPTBYASYMKEY
ENCRYPTBYCERTENCRYPTBYCERT DECRYPTBYCERTDECRYPTBYCERT
ASYMKEYPROPERTYASYMKEYPROPERTY ASYMKEY_IDASYMKEY_ID

署名および署名の確認Signing and signature verification

SIGNBYASYMKEYSIGNBYASYMKEY VERIFYSIGNEDBYASMKEYVERIFYSIGNEDBYASMKEY
SIGNBYCERTSIGNBYCERT VERIGYSIGNEDBYCERTVERIGYSIGNEDBYCERT
IS_OBJECTSIGNEDIS_OBJECTSIGNED

キーを自動的に処理する対称暗号化解除Symmetric decryption, with automatic key handling

DecryptByKeyAutoCertDecryptByKeyAutoCert

暗号化ハッシュEncryption hashing

HASHBYTESHASHBYTES

証明書の連絡先Certificate copying

CERTENCODED (Transact-SQL)CERTENCODED (Transact-SQL)
CERTPRIVATEKEY (Transact-SQL)CERTPRIVATEKEY (Transact-SQL)

参照See also

関数Functions
暗号化階層Encryption Hierarchy
権限の階層 (データベース エンジン)Permissions Hierarchy (Database Engine)
CREATE CERTIFICATE (Transact-SQL)CREATE CERTIFICATE (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)CREATE SYMMETRIC KEY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)CREATE ASYMMETRIC KEY (Transact-SQL)
セキュリティ カタログ ビュー (Transact-SQL)Security Catalog Views (Transact-SQL)