Column Encryption Key Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
Table encryption is designed to protect sensitive data, such as credit card numbers or national identification numbers (e.g. U.S. social security numbers), stored in Azure SQL Database or SQL Server databases. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the database engine, whether SQL database or SQL Server.
The Column Encryption Key wizard lets you specify the name and master key attributes.
To create a new column encryption key using a wizard:
- Open a creation wizard for a column encryption key. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - Column Encryption Key (SQL Server) - Properties.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Column Encryption Key (SQL Server) - Properties
When creating or editing an encryption key, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Encryption Key Name |
Provide a name of the encryption key being created. |
Master Key Name |
Add and review the Master Key associated with this encryption key. |