USE [UniversitySTDB]
GO
/****** Object: Table [dbo].[student] Script Date: 03/19/2014 22:02:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[student](
[StudentID] [nvarchar](36) NOT NULL,
[studentnumber] [nvarchar](50) NULL,
[StudentName] [nvarchar](50) NULL,
[ClassID] [nvarchar](50) NULL,
[Sex] [int] NULL,
[Age] [int] NULL,
[Nation] [nvarchar](50) NULL,
[NativePlace] [nvarchar](50) NULL,
[hostel] [nvarchar](50) NULL,
[Hphone] [nvarchar](50) NULL,
[Pname] [nvarchar](50) NULL,
[Pphone] [nvarchar](50) NULL,
[NState] [int] NULL,
[HCondition] [nvarchar](50) NULL,
[BornDate] [datetime] NULL,
[Status] [nvarchar](50) NULL,
[InDate] [datetime] NULL,
[PassWord] [nvarchar](50) NULL,
[Faddress] [nvarchar](200) NULL,
[MessageAdd] [nvarchar](200) NULL,
CONSTRAINT [PK_student] PRIMARY KEY CLUSTERED
(
[StudentID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'StudentID表示学生信息表的序列号，是其主键，具有唯一性，通过这项可以与各张相关联。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'student', @level2type=N'COLUMN',@level2name=N'StudentID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'studentnumber表示学生编号。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'student', @level2type=N'COLUMN',@level2name=N'studentnumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生信息表具有表序列号、学生编号、学生姓名、所属班级、性别、年龄、民族、籍贯、宿舍、宿舍电话、家长姓名、家长电话、目前状态、健康状况、出生日期、政治面貌、入学时间、密码、家庭住址、相片、备注这２１项目组成，其中表序列号是其主键，具有唯一性，可以通过这项同各个表相关联。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'student'
GO
/**************************************************************************************************************/
如何将[StudentID] [nvarchar](36) NOT NULL,这个属性我想改为[StudentID] [nvarchar](10) NOT NULL的
以下是我写的sql语句 但是无法执行 提升说有依赖关系存在，无法修改。
alter table [student] alter column [StudentID] [nvarchar](10) NOT NULL;
如何写啊，求大神帮忙啊