Is it possible to find constraints, (Not Null, Unique, Check, Primary key, Foreign key), in the Metadata Browser, (or using PROC METADATA or datastep metadata functions).
Yes, I found an UniqueKey association for a PhysicalTable directly, so I'm pretty sure you can find them all there.
They have to defined somewhere in the metadata, and there quite probably visible in the metadata browser.
/Linus
Yes, I found an UniqueKey association for a PhysicalTable directly, so I'm pretty sure you can find them all there.
They have to defined somewhere in the metadata, and there quite probably visible in the metadata browser.
/Linus
Great, thank you!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.