SQL添加删除、查询表、字段说明

添加表说明：

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录日志表' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'UP_LOGINLOG'
GO

删除表说明：

EXEC sys.sp_dropextendedproperty @name=N'MS_Description',@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'UP_LOGINLOG'

 

查询表说明：

SELECT TOP 1 P.[VALUE] FROM SYSCOLUMNS C
INNER JOIN SYSOBJECTS O ON C.ID=O.ID AND O.XTYPE='U' AND O.[NAME]<>'SYS.EXTENDED_PROPERTIES'
LEFT JOIN SYS.EXTENDED_PROPERTIES P ON C.ID=P.MAJOR_ID AND P.MINOR_ID=0
WHERE O.[NAME]='UP_USERINFO'

添加字段说明：

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录日志主键' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'UP_LOGINLOG', @level2type=N'COLUMN', @level2name=N'LOG_ID'
GO

 

删除字段说明：

EXEC sys.sp_dropextendedproperty @name=N'MS_Description',@level0type=N'SCHEMA', 
@level0name=N'dbo', @level1type=N'TABLE', @level1name=N'UP_LOGINLOG', 
@level2type=N'COLUMN', @level2name=N'LOG_ID'