Select a.name,b.value
from sys.syscolumns a left join sys.extended_properties b
on a.id=b.major_id AND a.colid = b.minor_id
Where a.ID=OBJECT_ID('[KS_DataBase2017].[dbo].[KS_AbnormalData201709]')
Select a.name,b.value
from sys.syscolumns a left join sys.extended_properties b
on a.id=b.major_id AND a.colid = b.minor_id
Where a.ID=OBJECT_ID('[KS_DataBase2017].[dbo].[KS_DataAnalysis2017]')
from sys.syscolumns a left join sys.extended_properties b
on a.id=b.major_id AND a.colid = b.minor_id
Where a.ID=OBJECT_ID('[KS_DataBase2017].[dbo].[KS_AbnormalData201709]')
Select a.name,b.value
from sys.syscolumns a left join sys.extended_properties b
on a.id=b.major_id AND a.colid = b.minor_id
Where a.ID=OBJECT_ID('[KS_DataBase2017].[dbo].[KS_DataAnalysis2017]')