text: ﻿
  
  CREATE view [inf].[vObjectDescription] as
  select
  SCHEMA_NAME(obj.[schema_id]) as SchemaName
  ,QUOTENAME(object_schema_name(obj.[object_id]))+'.'+quotename(obj.[name]) as ObjectName
  ,obj.[type] as [Type]
  ,obj.[type_desc] as [TypeDesc]
  ,ep.[value] as ObjectDescription
  from sys.objects as obj
  left outer join sys.extended_properties as ep on obj.[object_id]=ep.[major_id]
  											 and ep.[minor_id]=0
  											 and ep.[name]='MS_Description'
  where obj.[is_ms_shipped]=0
  and obj.[parent_object_id]=0
  
  GO
  EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Описание для объектов', @level0type = N'SCHEMA', @level0name = N'inf', @level1type = N'VIEW', @level1name = N'vObjectDescription';
  
  