如何给sqlserver 的表添加注释 类似于oracle的那种

[xlongbuilder]

字段注释貌似可以在设计表时就可以加或用脚本

那表如何加注释呢
比如

表名：user
注释：用户表

[懒牛科技]

EXECUTE sp_addextendedproperty N’MS_Description’, N’教师开课表’, N’user’, N’dbo’, N’table’, N’TeacherCourse’, NULL, NULL

[nzperfect]

楼主教你个办法： 你可以用sql server界面管理来建一个表，然后加注释，然后再导出这个表的脚本，就可以看到了。

[nzperfect]

[Quote=引用 2 楼 perfectaction 的回复:]
楼主教你个办法： 你可以用sql server界面管理来建一个表，然后加注释，然后再导出这个表的脚本，就可以看到了。
[/Quote]

例：

CREATE TABLE [dbo].[T_CollegeInfo](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CollegeName] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
	[HeadPhotoUrl] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
	[OrderBy] [int] NULL,
	[IsIndexShow] [char](1) COLLATE Chinese_PRC_CI_AS NULL,
	[IndexOrderBy] [int] NULL,
	[UseFlag] [char](1) COLLATE Chinese_PRC_CI_AS NULL,
	[AddTime] [datetime] NULL,
	[AddUserId] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK__T_CollegeInfo__4222D4EF] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学校名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_CollegeInfo', @level2type=N'COLUMN',@level2name=N'CollegeName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_CollegeInfo', @level2type=N'COLUMN',@level2name=N'OrderBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否显示在主页' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_CollegeInfo', @level2type=N'COLUMN',@level2name=N'IsIndexShow'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主页显示排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_CollegeInfo', @level2type=N'COLUMN',@level2name=N'IndexOrderBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否使用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_CollegeInfo', @level2type=N'COLUMN',@level2name=N'UseFlag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'增加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_CollegeInfo', @level2type=N'COLUMN',@level2name=N'AddTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'增加人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_CollegeInfo', @level2type=N'COLUMN',@level2name=N'AddUserId'

[nzperfect]

sp_addextendedproperty 用法参考联机文档。