Implicit pass through to get primary keys of SQL server table

David_Billa · Posted 10-23-2019 06:22 AM

Is there a way that we can get the primary key details informations from SQL server table using implicit pass through method?

Kurt_Bremser · Posted 10-23-2019 07:39 AM

If SQL Server provides a method to create a table from this information, you can retrieve that to SAS.

The equivalent to the SAS dictionary tables seem to be (I just googled a little) the system tables aka System Catalog Views in SQL Server. To know how to query them to find the primary keys, you best ask in a forum oriented on MS SQL Server.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Implicit pass through to get primary keys of SQL server table

Re: Implicit pass through to get primary keys of SQL server table

Registration is open

SAS Training: Just a Click Away