|
SELECT
atypes.name AS [Name],
satypes.name AS [Schema],
atypes.user_type_id AS [ObjectId],
asmbl.name AS [AssemblyName],
asmbl.assembly_id AS [AssemblyId],
ISNULL(atypes.assembly_class,N'') AS [AssemblyClass]
FROM
sys.assembly_types AS atypes
INNER JOIN sys.assemblies AS asmbl ON (asmbl.assembly_id = atypes.assembly_id) and (atypes.is_user_defined = 1)
INNER JOIN sys.schemas AS satypes ON satypes.schema_id = atypes.schema_id
LEFT OUTER JOIN sys.database_principals AS s1atypes ON s1atypes.principal_id = ISNULL(atypes.principal_id, (TYPEPROPERTY(QUOTENAME(SCHEMA_NAME(atypes.schema_id)) + '.' + QUOTENAME(atypes.name), 'OwnerId')));
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
My name is Robert Kanasz and I have been working with ASP.NET, WinForms and C# for several years.
MCSD - Web Applications
MCSE - Data Platform
MCPD - ASP.NET Developer 3.5
- Web Developer 4
MCITP - Database Administrator 2008
- Database Developer 2008
MCSA - SQL Server 2012
MCTS - .NET Framework 3.5, ASP.NET Applications
- SQL Server 2008, Database Development
- SQL Server 2008, Implementation and Maintenance
- .NET Framework 4, Data Access
- .NET Framework 4, Service Communication Applications
- .NET Framework 4, Web Applications
MS - Programming in HTML5 with JavaScript and CSS3 Specialist
Open source projects:
DBScripter - Library for scripting SQL Server database objects
Please, do not forget vote