create table c
( 课程号 char (3) not null ,
课程名 varchar (20) not null ,
学分 smallint null ,
预选课程号 char (3) null ,
教师 char (8) null ,
constraint fk_pcno foreign key (预选课程号) references c (课程号),
constraint ck_cno check (课程号 like ' [0-9] [0-9] '),
constraint pk_c primary key clustered ( 课程号 asc ),
) on primary
就会出现错误:提示primary附近有错误;
( 课程号 char (3) not null ,
课程名 varchar (20) not null ,
学分 smallint null ,
预选课程号 char (3) null ,
教师 char (8) null ,
constraint fk_pcno foreign key (预选课程号) references c (课程号),
constraint ck_cno check (课程号 like ' [0-9] [0-9] '),
constraint pk_c primary key clustered ( 课程号 asc ),
)
( 课程号 char (3) not null ,
课程名 varchar (20) not null ,
学分 smallint null ,
预选课程号 char (3) null ,
教师 char (8) null ,
constraint fk_pcno foreign key (预选课程号) references c (课程号),
constraint ck_cno check (课程号 like ' [0-9] [0-9] '),
constraint pk_c primary key clustered ( 课程号 asc )
) on [PRIMARY]
on filegroup stu_group
也提示 stu_group 附近有语法错误。
课程名 varchar (20) not null ,
学分 smallint null ,
预选课程号 char (3) null ,
教师 char (8) null ,
constraint fk_pcno foreign key (预选课程号) references c (课程号),
constraint ck_cno check (课程号 like ' [0-9] [0-9] '),
constraint pk_c primary key clustered ( 课程号 asc )
) on [primary]
加[]primary關健字
on stu_group--多了filegroup
这是测试例子,文件组名:Roy
USE [master]
GO/****** Object: Database [Test] Script Date: 10/27/2011 23:26:54 ******/
CREATE DATABASE [Test] ON PRIMARY
( NAME = N'Test', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Test.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ),
FILEGROUP [Roy]
( NAME = N'Test2', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Test2.ndf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Test_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Test_log.LDF' , SIZE = 832KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GOuse Test
go
create table c( 课程号 char (3) not null ,
课程名 varchar (20) not null ,
学分 smallint null ,
预选课程号 char (3) null ,
教师 char (8) null ,
constraint fk_pcno foreign key (预选课程号) references c (课程号),
constraint ck_cno check (课程号 like ' [0-9] [0-9] '),
constraint pk_c primary key clustered ( 课程号 asc )
) on [roy]
on stu_group3; 错误
on [stu_group3];错误
on filegroup stu_group3;错误
on filegroup [stu_gruoup3];错误
代码后的分号不算。
有谁能给咱解决一下啊!