用sql 語句給字段添加描述

IF not exists

(SELECT * FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'strTableName', 'column', ''strColumnName''))

BEGIN

exec sp_addextendedproperty

'MS_Description', 'strColumnDesc ', 'user', 'dbo', 'table','strTableName', 'column', 'strColumnName'

END

ELSE

BEGIN

exec sp_updateextendedproperty 'MS_Description', 'strColumnDesc ', 'user', 'dbo', 'table','strTableName', 'column', 'strColumnName'

END

用sql語句查詢字段描述

SELECT * FROM ::fn_listextendedproperty

(null,'user','dbo','table','APPL_CREDIT','column',null)

用sql語句刪除字段描述

EXEC sys.sp_dropextendedproperty

'MS_Description' ,'user','dbo','table','APPL_CREDIT','column','APPLNO'

1> sql server 怎么查詢數據字段說明？

可以在extended_properties視圖中進行查看：

sql：SELECT * FROM sys.extended_properties WHERE major_id = OBJECT_ID ('TABLENAME' )；

解釋：以上語句就是從視圖中獲取到對象的所有描述信息。并且表名必須用大寫(TABLANAME換成相應的表名)