SQL语言操作数据表
---检查数据库是否存在 use master go if exists(select * from sysdatabases where) drop database studentdb ----创建数据库 Create database studentdb on primary ( name='sudent', filename='d:\data\student.mdf', size=10, maxsize=50, filegrowth=3
---检查数据库是否存在
use master
go
if exists(select * from sysdatabases where)
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)
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)
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)
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
,香港服务器,美国空间,香港虚拟主机