topic Help needed: Is it possible to view integrity constraints in the Metadata Browser in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Help-needed-Is-it-possible-to-view-integrity-constraints-in-the/m-p/44101#M380 <HTML><HEAD></HEAD><BODY><P> Great, thank you!</P></BODY></HTML> Fri, 11 Nov 2011 09:46:35 GMT KJD 2011-11-11T09:46:35Z Help needed: Is it possible to view integrity constraints in the Metadata Browser https://communities.sas.com/t5/SAS-Data-Management/Help-needed-Is-it-possible-to-view-integrity-constraints-in-the/m-p/44099#M378 <HTML><HEAD></HEAD><BODY><P>Is it possible to find constraints,<EM> (Not Null, Unique, Check, Primary key, Foreign key)</EM>, in the Metadata Browser, (or using PROC METADATA or datastep metadata functions).</P><P></P><P></P><P><IMG alt="MetadataBrowser.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://communities.sas.com/legacyfs/online/1250_MetadataBrowser.JPG" width="450" /> </P></BODY></HTML> Wed, 09 Nov 2011 11:33:35 GMT https://communities.sas.com/t5/SAS-Data-Management/Help-needed-Is-it-possible-to-view-integrity-constraints-in-the/m-p/44099#M378 KJD 2011-11-09T11:33:35Z Help needed: Is it possible to view integrity constraints in the Metadata Browser https://communities.sas.com/t5/SAS-Data-Management/Help-needed-Is-it-possible-to-view-integrity-constraints-in-the/m-p/44100#M379 <HTML><HEAD></HEAD><BODY><P> Yes, I found an UniqueKey association for a PhysicalTable directly, so I'm pretty sure you can find them all there. </P><P>They have to defined somewhere in the metadata, and there quite probably visible in the metadata browser.</P><P></P><P>/Linus</P></BODY></HTML> Thu, 10 Nov 2011 16:09:08 GMT https://communities.sas.com/t5/SAS-Data-Management/Help-needed-Is-it-possible-to-view-integrity-constraints-in-the/m-p/44100#M379 LinusH 2011-11-10T16:09:08Z Help needed: Is it possible to view integrity constraints in the Metadata Browser https://communities.sas.com/t5/SAS-Data-Management/Help-needed-Is-it-possible-to-view-integrity-constraints-in-the/m-p/44101#M380 <HTML><HEAD></HEAD><BODY><P> Great, thank you!</P></BODY></HTML> Fri, 11 Nov 2011 09:46:35 GMT https://communities.sas.com/t5/SAS-Data-Management/Help-needed-Is-it-possible-to-view-integrity-constraints-in-the/m-p/44101#M380 KJD 2011-11-11T09:46:35Z