添加表说明:
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'