SAS Component Language Dictionary

ICDELETE

Drops an integrity constraint from a SAS table

Category:

SAS Table

Syntax
Details
Example
See Also

Syntax

sysrc=ICDELETE(table-id,icname);

sysrc

contains the status of the operation:

=0	successful
>0	not successful
<0	the operation was completed with a warning

Type: Numeric

table-id

contains the identifier for the SAS table, which is returned by the OPEN function. An integrity constraint can be dropped only from a SAS table that is open in NEW or UTILITY mode.

Type: Numeric

icname

is the name of the integrity constraint to delete.

Type: Character

Details

Referential integrity constraints (where ictype is FOREIGN) provide a link between SAS tables. Part of the link mechanism involves the name of the table. Therefore, renaming or deleting a table that has a FOREIGN integrity constraint is not allowed until after the FOREIGN key is deleted.

Example

Delete the integrity constraint UQ from the table MYLIB.ONE. The constraint was created in Example.

table1=open('mylib.one','V');
rc=icdelete(table1,'uq');
rc=close(table1);