create database for Full Database Encryption

You can use the create database command to create a fully encrypted database.

Specify whether to encrypt a database when you create it, and all the data inserted into the database becomes encrypted automatically. The size of the database does not change when it is encrypted, and all storage access functions work identically whether a database is encrypted or not. The types of databases that support encryption are:
  • Normal user database
  • Temporary database
  • Archive database
You cannot encrypt an in-memory database.

Syntax

create [temporary] database database_name
    encrypt with key_name

Parameters

Examples

Related concepts
Create an Encrypted Database
create archive database for Full Database Encryption
dbencryption_status
Full Database Encryption and System Changes
sp_helpdb
sp_encryption
ddlgen
sybmigrate
Changed System Tables
create archive database for Full Database Encryption
Create an Encrypted Database
Related reference
alter database for Full Database Encryption
create encryption key
drop encryption key
Related information
alter database for Full Database Encryption