Chapter Contents |
Previous |
Next |
ICDELETE |
Category: | SAS Table |
Syntax | |
Details | |
Example | |
See Also |
Syntax |
sysrc=ICDELETE(table-id,icname); |
=0 | successful |
>0 | not successful |
<0 | the operation was completed with a warning |
Type: Numeric
Type: Numeric
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);
See Also |
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.