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

，香港服务器，美本文来源gao@daima#com搞(%代@#码@网2国空间，香港虚拟主机

喜欢 (0)赏

[搞代码]

分享 (0)