![]() |
Production Ready Macros for SAS Application Developers
https://github.com/sasjs/core
|
Get constraint details at column level. More...
Go to the source code of this file.
Useful for capturing constraints before they are dropped / reapplied during an update.
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) ); %mp_getconstraints(lib=work,ds=example,outds=work.constraints)
lib= | The target library (default=WORK) |
ds= | The target dataset. Leave blank (default) for all datasets. |
outds | the output dataset |
Definition in file mp_getconstraints.sas.