sp_primary_keys_rowset (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_primary_keys_rowset(nvarchar @table_name
, nvarchar @table_schema)

MetaData:

   
create procedure sys.sp_primary_keys_rowset  
(  
    @table_name         sysname,  
    @table_schema       sysname = null  
)  
as  
    select  
        TABLE_CATALOG   = s_pkv.TABLE_CATALOG,  
        TABLE_SCHEMA    = s_pkv.TABLE_SCHEMA,  
        TABLE_NAME      = s_pkv.TABLE_NAME,  
        COLUMN_NAME     = s_pkv.COLUMN_NAME,  
        COLUMN_GUID     = s_pkv.COLUMN_GUID,  
        COLUMN_PROPID   = s_pkv.COLUMN_PROPID,  
        ORDINAL         = s_pkv.ORDINAL,  
        PK_NAME         = s_pkv.PK_NAME  
    from  
        sys.spt_primary_keys_view s_pkv  
    where  
        (@table_schema is null and s_pkv.TABLE_NAME = @table_name) or  
        s_pkv.object_id = object_id(quotename(@table_schema) + '.' + quotename(@table_name))  
    order by 2, 3