sql创建表格语句主键自动增加

create table rpinfo
( rpno int identity(1,1) not null,
sno varchar(10) not null,
rpreason varchar(50),
rpcontent varchar(20),
rpterm smallint,
CONSTRAINT [pk_rpinfo] PRIMARY KEY CLUSTERED
(
[rpno ]
) ON [PRIMARY]
)
---外键没有提供外键表，所以没有写，如果需要的话可以用下面的语句创建：
create table rpinfo
( rpno int identity(1,1) not null,
sno varchar(10) not null,
rpreason varchar(50),
rpcontent varchar(20),
rpterm smallint,
CONSTRAINT [pk_rpinfo] PRIMARY KEY CLUSTERED
(
[rpno ]
) ON [PRIMARY],
CONSTRAINT [FK_rpinfo_test] FOREIGN KEY
(
[sno ]
) REFERENCES [学号表名] (
[学号表的主键字段名]
)
)