The following example updates an access descriptor AdLib.Employ on the Oracle table Employees. The original access descriptor includes all of the columns in the table. The updated access descriptor omits the Salary and BirthDate columns.

You can use the LIST statement to write all variables to the SAS log so that you can see the complete access descriptor before you update it.

proc access dbms=oracle ad=adlaib.employ;

   /* update access descriptor  */

   update adlib.employ.access;
   drop salary birthdate;
   list all;
run;