Chapter Contents |
Previous |
Next |
ICTYPE |
Category: | SAS Table |
Syntax | |
Details | |
Example | |
See Also |
Syntax |
ictype=ICTYPE(table-id,icname); |
'CHECK' | |
'FOREIGN' | |
'NOT-NULL' | |
'PRIMARY' | |
'UNIQUE' |
Type: Character
Type: Numeric
Type: Character
Details |
ICTYPE returns the type of integrity constraint for a SAS table when you specify the name of the constraint.
Example |
Return the type of the UQ integrity constraint that
is assigned to the SAS table MYLIB.ONE. Because the constraint UQ (which was
created in ICCREATE
) was UNIQUE, the value of TYPE will be UNIQUE
.
tableid=open('mylib.one','i'); type=ictype(tableid,'uq'); ...more SCL statements... rc=close(tableid);
See Also |
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.