Displaying Integrity Constraints for a Table
Overview
Sometimes you want to add data to a table but you are
not sure what integrity constraints, if any, the table has. To display
only the integrity constraints for a specified table, use a DESCRIBE
TABLE CONSTRAINTS statement. (The DESCRIBE TABLE statement, which
is discussed earlier in this chapter, lists both a CREATE TABLE statement
and the table's integrity constraints in the SAS log.)
Note: Some versions of SAS display
information about integrity constraints in output as well as in the
SAS log.
General form, DESCRIBE
TABLE CONSTRAINTS statement:
DESCRIBE TABLE CONSTRAINTS table-name-1<,
... table-name-n>;
table-name
specifies the table to be ... |
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.