sql 给列名添加描述 （sql server 2012篇）

--1.我们还没有表格，先创建一个表格
CREATE TABLE [dbo].[tb_Order](
	[TID] [uniqueidentifier] primary key NOT NULL,
	[SchoolID] [varchar](50) NULL,
	[CreateDateTime] [datetime] NULL,
	[CreatePersonID] [varchar](50) NULL,
	[LastUpdateDateTime] [datetime] NULL,
	[LastUpdatePersonID] [varchar](50) NULL,
	[IsDelete] [int] NULL,
	[OrderNo] [varchar](50) NOT NULL,
	[OrderType] [int] NULL,
	[RealPayIntegral] [int] NULL,
	[OrderAmount] [decimal](18, 2) NULL,
	[DiscountAmount] [decimal](18, 2) NULL,
	[RealPayAmount] [decimal](18, 2) NULL,
	[TotalCost] [decimal](18, 2) NULL,
	[StudentName] [varchar](50) NULL,
	[StudentPhone] [varchar](15) NULL,
	[OrderStatus] [int] not NULL,
	[TotalCount] [int] NULL,
	[StaffId] [uniqueidentifier] NULL,
	[Remark] [varchar](300) NULL,
	[RM_A] [varchar](50) NULL,
	[RM_B] [varchar](50) NULL,
) ON [PRIMARY]
GO

--2.添加/修改/删除描述
-- 添加描述模板
EXECUTE sp_addextendedproperty N'MS_Description',N'字段说明',N'user',N'dbo',N'table',N'表名',N'column',N'字段名'; 
 

--实例： 添加OrderStatus描述   
EXECUTE sp_addextendedproperty N'MS_Description',N'订单状态：(0:待支付;1:下单成功;2:待发货;3:已发货;4:已收货;5:已完成;6:发起退款;7:已退款;8:已取消;)',N'user',N'dbo',N'table',N'tb_Order',N'column',N'OrderStatus';


-- 修改描述模板
EXECUTE sp_updateextendedproperty N'MS_Description',N'字段说明',N'user',N'dbo',N'table',N'表名',N'column',N'字段名'; 
 
-- 删除描述模板
EXECUTE sp_dropextendedproperty 'MS_Description',N'user',N'dbo',N'table',N'表名',N'column',N'字段名'

 最终结果：