https://communities.sas.com/t5/SAS-Programming/Implicit-pass-through-to-get-primary-keys-of-SQL-server-table/m-p/598665#M172663 <P>If SQL Server provides a method to create a table from this information, you can retrieve that to SAS.</P> <P>The equivalent to the SAS dictionary tables seem to be (I just googled a little) the system tables aka <A href="https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/catalog-views-transact-sql?view=sql-server-ver15" target="_blank" rel="noopener">System Catalog Views</A> 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.</P> Wed, 23 Oct 2019 11:39:20 GMT Kurt_Bremser 2019-10-23T11:39:20Z https://communities.sas.com/t5/SAS-Programming/Implicit-pass-through-to-get-primary-keys-of-SQL-server-table/m-p/598654#M172656 Is there a way that we can get the primary key details informations from SQL server table using implicit pass through method? Wed, 23 Oct 2019 10:22:26 GMT https://communities.sas.com/t5/SAS-Programming/Implicit-pass-through-to-get-primary-keys-of-SQL-server-table/m-p/598654#M172656 David_Billa 2019-10-23T10:22:26Z https://communities.sas.com/t5/SAS-Programming/Implicit-pass-through-to-get-primary-keys-of-SQL-server-table/m-p/598665#M172663 <P>If SQL Server provides a method to create a table from this information, you can retrieve that to SAS.</P> <P>The equivalent to the SAS dictionary tables seem to be (I just googled a little) the system tables aka <A href="https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/catalog-views-transact-sql?view=sql-server-ver15" target="_blank" rel="noopener">System Catalog Views</A> 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.</P> Wed, 23 Oct 2019 11:39:20 GMT https://communities.sas.com/t5/SAS-Programming/Implicit-pass-through-to-get-primary-keys-of-SQL-server-table/m-p/598665#M172663 Kurt_Bremser 2019-10-23T11:39:20Z