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.
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!