sp_usertypes_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_usertypes_rowset(nvarchar @type_name
, nvarchar @type_schema)

MetaData:

   
create procedure sys.sp_usertypes_rowset  
(  
    @type_name      sysname,  
    @type_schema    sysname = null  
)  
as  
    select  
        UDT_CATALOGNAME         = db_name(),  
        UDT_SCHEMANAME          = schema_name(u.schema_id),  
        UDT_NAME                = convert(sysname,u.name),  
        UDT_ASSEMBLY_TYPENAME   = u.assembly_qualified_name  
    from  
        sys.assemblies a inner join  
        sys.assembly_types u on  
            (  
                a.assembly_id = u.assembly_id  
            )  
    where  
        u.name = @type_name and  
        (@type_schema is null or @type_schema = schema_name(u.schema_id))  
    order by 1, 2, 3