Column Master 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 Master Key wizard lets you specify the name and attributes of the master key constraint.
To create a new column master key using a wizard:
- Open a creation wizard for a column master 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 Master 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 Master Key (SQL Server) - Properties
When creating or editing a master key, this tab/panel lets you work with the following settings:
| Setting | Description |
|---|---|
|
Master Key Name |
Provide a name of the master key being created. |
|
Key Store Provider Name |
Provide the name of the Key Store Provider. |