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

来源：互联网发布：godaddy域名续费价格编辑：程序博客网时间：2024/05/27 01:07

添加表说明：

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 CINNER 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=0WHERE 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'

0 0