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
database_name – is the name of the encrypted database you are
creating.
key_name – is the name of the database encryption key.
Examples
Create Encrypted Database from Scratch – Creates an encrypted database called demodb with a log
called demodev on a machine called
demologdev, using an encrypttion key called
dbkey:
create database demodb on demodev log on demologdev encrypt with dbkey