sp_table_types_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_table_types_rowset(nvarchar @table_name
, nvarchar @table_schema)

MetaData:

   
create procedure sys.sp_table_types_rowset  
(  
    @table_name     sysname = null,  
    @table_schema   sysname = null  
)  
as  
    select  
        TABLE_CATALOG   = s_tr.TABLE_CATALOG,  
        TABLE_SCHEMA    = s_tr.TABLE_SCHEMA,  
        TABLE_NAME      = s_tr.TABLE_NAME,  
        TABLE_TYPE      = s_tr.TABLE_TYPE,  
        TABLE_GUID      = s_tr.TABLE_GUID,  
        DESCRIPTION     = s_tr.DESCRIPTION,  
        TABLE_PROPID    = s_tr.TABLE_PROPID,  
        DATE_CREATED    = s_tr.DATE_CREATED,  
        DATE_MODIFIED   = s_tr.DATE_MODIFIED  
    from  
        sys.spt_table_types_view s_tr  
    where  
        (@table_name is null or s_tr.TABLE_NAME = @table_name) and  
        (@table_schema is null or schema_id(@table_schema) = s_tr.schema_id)  
    order by 4, 2, 3