The ACCESS Procedure for Relational Databases |
Drops a column so that it cannot be selected in a view descriptor
Applies to: |
access and view descriptors
|
Interaction: |
RESET, SELECT
|
DROP <'>column-identifier-1<'>
<...<'>column-identifier-n<'>>;
|
-
column-identifier
-
specifies the column name or the positional
equivalent from the LIST statement, which is the number that represents the
column's place in the access descriptor. For example, to drop the third and
fifth columns, submit this statement:
drop 3 5;
The DROP statement drops the specified column(s) from
a descriptor. You can drop a column when creating or updating an access descriptor;
you can also drop a column when updating a view descriptor. If you drop a
column when creating an access descriptor, you cannot select that column when
creating a view descriptor that is based on the access descriptor. The underlying
DBMS table is unaffected by this statement.
To display a column that was previously dropped, specify
that column name in the RESET statement. However, doing so also resets all
column attributes--such as the SAS variable name and format--to
their default values.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.