Hi,各位先進大家好:
請問是否可以用程式取得資料庫中各資料表的COMMENT?
謝謝!

MS-SQL,

select top 100 * from xxx
;
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'xxx' and SCHEMA_NAME(tbl.schema_id)=N'dbo')
ORDER BY
[Name] ASC
;
SELECT *
FROM fn_listextendedproperty (NULL, 'schema','dbo', 'table', 'xxx', default, default)
;
EXEC sys.sp_addextendedproperty
@name=N'xFieldName', @value=N'中文註解'
, @level0type=N'SCHEMA', @level0name=N'dbo'
, @level1type=N'TABLE', @level1name=N'xxx'
;
EXEC sys.sp_updateextendedproperty
@name=N'xFieldName', @value=N'中文註解'
, @level0type=N'SCHEMA', @level0name=N'dbo'
, @level1type=N'TABLE', @level1name=N'xxx'
;
EXEC sys.sp_dropextendedproperty
@name=N'sFieldName'
, @level0type=N'SCHEMA', @level0name=N'dbo'
, @level1type=N'TABLE', @level1name=N'xxx'