To encrypt tables in your database, table encryption must already be enabled in the database.
When you encrypt a table, the table encryption settings that were specified at database creation time, such as simple, AES, FIPS, and so on, are applied to the table.
Create a table using the ENCRYPTED clause of the CREATE TABLE statement.
The following command creates a encrypted table Employees:
CREATE TABLE Employees ( MemberID CHAR(40), CardNumber INTEGER ) ENCRYPTED;