ＡｉＴパートナー公開情報

/*

        extendedproperty?ɗ\?ߒl?????Ă????ƊǗ??????₷??

        MS_Description = ?e?[?u????

        Description?@=?@?e?[?u???̗p?r?Ȃǂ̐???

*/

select        

        ROW_NUMBER() over (order by A.Name) as TableNo,

        A.id,

        A.Name as TableName,

        D.value as TableNameJa,

        D2.value as TableDescription,

        A.crdate

from sys.sysobjects A

        left join sys.extended_properties D on

                 D.major_id = A.id AND D.minor_id  = 0

        left join (Select * From sys.extended_properties where Name='Description') D2 on

                 D2.major_id = A.id AND D2.minor_id  = 0

where A.xtype='U'        

order by A.Name