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_100(nvarchar @object)MetaData:
create procedure sys.sp_tablecollations_100
(
@object nvarchar(4000)
)
as
select
colid = s_tcv.colid,
name = s_tcv.name,
tds_collation = s_tcv.tds_collation_100,
"collation" = s_tcv.collation_100
from
sys.spt_tablecollations_view s_tcv
where
s_tcv.object_id = object_id(@object, 'local')
order by colid
No comments:
Post a Comment