June 13, 2012

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

No comments:

Post a Comment

Total Pageviews