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