求这道题目 关于SQL的

来源：百度知道 编辑：UC知道 时间：2024/05/16 11:03:17
3）在企业管理器中新建一个Departments表。
Departments表的结构如下：

列名 数据类型 长度 是否允许为空 说明
DepartmentID Char 3 × 部门编号，主键
DepartmentName Char 20 × 部门名
Note Text 16 √ 备注

CREATE TABLE [dbo].[Departments](
[DepartmentID] [char](3) COLLATE Chinese_PRC_CI_AS NOT NULL,
[DepartmentName] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Note] [text] COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_Departments] PRIMARY KEY CLUSTERED
(
[DepartmentID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_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'Departments', @level2type=N'COLUMN', @level2name=N'DepartmentID'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门名 ' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Departments', @level2type=N'COLU