Advantage Database Server

sp_DecryptTable

Advantage SQL Engine

sp_DecryptTable

Advantage SQL Engine

Previous topic Next topic  

sp_DecryptTable

Advantage SQL Engine

Previous topic Next topic  

Decrypts a table.

 

Syntax

sp_DecryptTable(

 TableName,Character,515 )

sp_DecryptTable(

 TableName,Character,515,

 Password,Character,20 )

 

Parameters

TableName (I)

Name of table to decrypt.  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 decrypting free tables. For data dictionary bound tables, this parameter is not specified.

 

Remarks

sp_DecryptTable can be used to decrypt data dictionary tables and free tables. This procedure, in conjunction with sp_EncryptTable, can be used to convert tables between different encryption types.

 

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_EncryptTable

sp_SetDDEncryptionType

Encryption Overview