sys.extended_properties

extended_properties.sql

select * from sys.extended_properties

EXEC sp_addextendedproperty   
@name = N'Description',   
@value = N'بانک اطلاعاتی بانک';  

EXEC sys.sp_addextendedproperty @name=N'MS_Description', 
@value=N'گروه مرجع' , @level0type=N'SCHEMA',@level0name=N'dbo'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', 
@value=N'حساب' , @level0type=N'SCHEMA',@level0name=N'dbo', 
@level1type=N'TABLE',@level1name=N'Accounts'

SELECT p.name AS [Name],p.value
FROM sys.tables AS tbl
INNER JOIN sys.extended_properties AS p 
	ON p.major_id=tbl.object_id AND p.minor_id=0 AND p.class=1
WHERE (tbl.name=N'Accounts' and SCHEMA_NAME(tbl.schema_id)=N'dbo')
ORDER BY [Name] ASC