SAS Component Language Dictionary

ICTYPE

Returns the type of integrity constraint that is assigned to a SAS table

Category:

SAS Table

Syntax
Details
Example
See Also

Syntax

ictype=ICTYPE(table-id,icname);

ictype

contains the type of integrity constraint that is returned. The constraints are listed below and are defined in ICCREATE:

	'CHECK'
	'FOREIGN'
	'NOT-NULL'
	'PRIMARY'
	'UNIQUE'

Type: Character

table-id

contains the identifier for the SAS table, which is returned by the OPEN function.

Type: Numeric

icname

is the name of the integrity constraint.

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 the example for 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);