利用T--SQL语言操作数据表
use master
go
if exists(select * from sysdatabases where name='studentdb')
drop database studentdb
Create database studentdb
on primary (
name='sudent',
filename='d:\data\student.mdf',
size=10,
maxsize=50,
filegrowth=3
)
log on (
name='student-log',
filename='d:\data\student-log.ldf',
size=15,
filegrowth=15%
)
---创建第一张表
use studentdb
go
if exists (select * from sysobjects where name='t_student')
drop table t_student
create table t_student
(
sno char(3) not null,
sname char(20) null,
sdenger char(2) not null,
sbirth datetime null,
sclass varchar(20) not null
)
---创建第二张表
use studentdb
go
if exists (select * from sysobjects where name='t_course')
drop table t_course
create table t_course
(
cno char(3) not null,
cname char(20) null
)
--创建第三张表
use studentdb go
if exists (select * from sysobjects where name='t_score')
drop table t_score
create table t_score
(
sno char(3) not null,
cno char(3) not null,
score int not null
)
--修改列
alter table t_student
alter column sno char(12)
--增加列
alter table t_student
add sfavorate char(30)
--删除列
alter table t_student
drop column sfavorate
--查看表
sp_help t_student
--删除表
drop table t_student