Skip to content

Commit 64d3f3d

Browse files
authored
Update drop-symmetric-key-transact-sql.md
Fixes https://github.com/MicrosoftDocs/sql-docs/issues/4698 Verified that the key can be dropped even if it's open
1 parent 827434b commit 64d3f3d

1 file changed

Lines changed: 1 addition & 2 deletions

File tree

docs/t-sql/statements/drop-symmetric-key-transact-sql.md

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -48,9 +48,8 @@ DROP SYMMETRIC KEY symmetric_key_name [REMOVE PROVIDER KEY]
4848
Removes an Extensible Key Management (EKM) key from an EKM device. For more information about Extensible Key Management, see [Extensible Key Management (EKM)](../../relational-databases/security/encryption/extensible-key-management-ekm.md).
4949

5050
## Remarks
51-
If the key is open in the current session the statement will fail.
5251

53-
If the asymmetric key is mapped to an Extensible Key Management (EKM) key on an EKM device and the **REMOVE PROVIDER KEY** option is not specified, the key will be dropped from the database but not the device, and a warning will be issued.
52+
If the asymmetric key is mapped to an Extensible Key Management (EKM) key on an EKM device and the **REMOVE PROVIDER KEY** option is not specified, the key will be dropped from the database but not the device, and a warning will be issued.
5453

5554
## Permissions
5655
Requires CONTROL permission on the symmetric key.

0 commit comments

Comments
 (0)