SQL Anywhere® Server - Database Administration  > Keeping Your Data Secure  > Encrypting a database  > Encrypting portions of a database  > Table encryption

Encrypting tables

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.

To encrypt a table at table creation

• 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;

To decrypt a table after it has been created

• Decrypt a table with the NOT ENCRYPTED clause of the ALTER TABLE statement.

  The following command decrypts the Employees table:

  ALTER TABLE Employees 
  NOT ENCRYPTED;

See also

• Encrypting a database
• Enabling table encryption
• CREATE TABLE statement
• ALTER TABLE statement

---