Advantage Database Server

sp_EncryptTable

Advantage SQL Engine

sp_EncryptTable

Advantage SQL Engine

Previous topic Next topic  

sp_EncryptTable

Advantage SQL Engine

Previous topic Next topic  

Encrypts a table.

 

Syntax

sp_EncryptTable(

 TableName,Character,515 )

sp_EncryptTable(

 TableName,Character,515,

 Password,Character,20 )

 

Parameters

TableName (I)

Name of table to encrypt.  This can include path information for free tables if the table is in a different folder from the connection path.

Password (I)

The password to use when encrypting free tables. For data dictionary bound tables, this parameter is not specified.

 

Remarks

sp_EncryptTable can be used to encrypt data dictionary tables and free tables. When using AES encryption, a different file format is required and this procedure will update the table as needed for the encryption type. This procedure, in conjunction with sp_DecryptTable, can be used to convert tables between different encryption types.

 

For free tables, the encryption type used for the encryption is the one specified by the EncryptionType connection string option for the connection. For data dictionary tables, the encryption type will match that of the dictionary (the EncryptionType specified when the dictionary was created).

 

 

Example

-- Change the encryption type of an encrypted free table to the connection's current
-- encryption type:
EXECUTE PROCEDURE sp_DecryptTable( 'sometable.adt', 'password' );
EXECUTE PROCEDURE sp_EncryptTable( 'sometable.adt', 'password' );

 

See Also

sp_DecryptTable

sp_SetDDEncryptionType

Encryption Overview