June 11, 2012

sp_tablecollations_90 (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_90(nvarchar @object)

MetaData:

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

No comments:

Post a Comment

Total Pageviews