select into

select into requires column level permissions, including decrypt, on the source table.

Syntax

Encrypt columns on the new table using this syntax:

select [all|distinct] < column_list> 
           into target_table 
           [(colname encrypt [with [database.[owner].]keyname] 
           [,colname encrypt
           [with [database.[owner].]keyname]])] 
       from tabname | viewname

Example

Encrypting creditcard column in the table.

select creditcard, custid, sum(amount) into        #bigspenders
       (creditcard encrypt with           cust.database.new_cc_key)
       from daily_xacts group by creditcard
       having sum(amount) > $5000

Copyright © 2005. Sybase Inc. All rights reserved.

View this release bulletin as PDF