如何给sqlserver 的表添加注释 类似于oracle的那种 字段注释貌似可以在设计表时就可以加或用脚本那表如何加注释呢比如 表名:user注释:用户表 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 EXECUTE sp_addextendedproperty N’MS_Description’, N’教师开课表’, N’user’, N’dbo’, N’table’, N’TeacherCourse’, NULL, NULL 楼主教你个办法: 你可以用sql server界面管理来建一个表,然后加注释,然后再导出这个表的脚本,就可以看到了。 例: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]GOSET ANSI_PADDING OFFGOEXEC 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'GOEXEC 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'GOEXEC 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'GOEXEC 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'GOEXEC 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'GOEXEC 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'GOEXEC 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' sp_addextendedproperty 用法参考联机文档。 求助,游标 如何查询test表中值=3的所有字段名称? 求一sql语句! 把select 随机排序的结果保存在存储过程中的临时表中 帮忙看下这段SQL语句的错误在哪? 我要在windows2003中安装sqlserver怎么搞?始终装不上,急啊`` SQL 分组问题 一个关于自增长值的问题 一个数据库比较基础的问题,表与表之间的关系到底有什么用?能告诉我吗? 在VFP中如何实现数据共享------大虾指教! 如何显示输出(有关连接) 为什么sqlcmd不显示某些执行结果?
例:
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'