摘要:
declare @table_name nvarchar(50)declare @column_name nvarchar(50)declare @Description nvarchar(50)--01set @table_name=N'CCOSBusiness'set @column_name=N'BusinessId'set @Description=N'业务流水号'IF EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCH 阅读全文
摘要:
方法1:从函数里面获得IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'T', N'COLUMN',N'ID'))EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标志ID' , @level0type=N' 阅读全文