|
sp_EncryptTable Advantage SQL Engine |
|
|
|
|
sp_EncryptTable Advantage SQL Engine |
|
|
sp_EncryptTable
Advantage SQL Engine
|
sp_EncryptTable Advantage SQL Engine |
|
|
|
|
sp_EncryptTable Advantage SQL Engine |
|
|
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