首页 > 代码库 > MSSQL创建表时添加说明

MSSQL创建表时添加说明

示例:

IF OBJECT_ID(MemberExt1) IS NOT NULL    DROP TABLE MemberExt1GOCREATE TABLE MemberExt1    (      MemberId INT NOT NULL,      QRImage NVARCHAR(500) ,      Url NVARCHAR(500)    )EXEC sp_addextendedproperty NMS_Description,     N记录Member的二维码和个人推荐URL, Nuser, Ndbo,    Ntable, NMemberExt1, NULL, NULLEXEC sp_addextendedproperty NMS_Description,     N会员ID, Nuser, Ndbo,    Ntable, NMemberExt1, Ncolumn, NMemberIdEXEC sp_addextendedproperty NMS_Description,     N二维码的存放位置, Nuser, Ndbo,    Ntable, NMemberExt1, Ncolumn, NQRImageEXEC sp_addextendedproperty NMS_Description,     N个人推荐URL, Nuser, Ndbo,    Ntable, NMemberExt1, Ncolumn, NUrl