Macros for SAS Application Developers File Reference

Delete constraionts. More...

Go to the source code of this file.

Detailed Description

Takes the output from as input

  proc sql;
  create table work.example(
    TX_FROM float format=datetime19.,
    DD_TYPE char(16),
    DD_SOURCE char(2048),
    DD_SHORTDESC char(256),
    constraint pk primary key(tx_from, dd_type,dd_source),
    constraint unq unique(tx_from, dd_type),
    constraint nnn not null(DD_SHORTDESC)

[in]inds=(mp_getconstraints) The input table containing constraint info
[out]outds=(mp_deleteconstraints) Table containing the drop statements (drop_statement column)
[in]execute=(NO) YES|NO - default is NO. To actually drop, use YES.
Allan Bowe

Definition in file