sp_tablecollations (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_tablecollations(nvarchar @object)

MetaData:

   
create procedure sys.sp_tablecollations  
(  
    @object nvarchar(4000)  
)  
as  
    select  
        colid               = s_tcv.colid,  
        name                = s_tcv.name,  
        tds_collation       = s_tcv.tds_collation_28,  
        "collation"         = s_tcv.collation_28  
    from  
        sys.spt_tablecollations_view s_tcv  
    where  
        s_tcv.object_id = object_id(@object, 'local')  
    order by colid