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

Declare @TableName as nvarchar(50)

Set @TableName = 'AccessServerLog'

/*

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

        MS_Description = ?J???????̐???

        DataSours?@=?@?f?[?^?̎擾???̐???

        Description?@=?@?J?????Ɋ֘A??????l?????Ă????i0:????/1:?L???Ȃǁj

*/

select        

        A.Name as TableName,

        B.colid as ColmunID,

        B.Name as ColmunName,

        D.value as MS_Description,

        D1.value as DataSours,

        D2.value as Description,

        C.Name as DataType,

        B.length,

        B.xprec,

        B.xscale,

        A.crdate

from sys.sysobjects A        

        inner join sys.syscolumns B on A.id = B.id

        left join sys.types C on B.xtype=C.system_type_id and B.xusertype=C.user_type_id

        left join (Select * From sys.extended_properties where Name='MS_Description') D on

                 D.major_id = B.id AND D.minor_id = B.colid

        left join (Select * From sys.extended_properties where Name='DataSours') D1 on

                 D1.major_id = B.id AND D1.minor_id = B.colid

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

                 D2.major_id = B.id AND D2.minor_id = B.colid

where A.xtype='U'

        --and A.Name =@TableName

order by A.Name,B.colid