数据库操作实例--数据库，数据表，数据记录基本操作

–SqlServer数据库操作实例

-------------------------------------------------数据库操作-----------------------------------------------
–使用默认方式创建数据库

create database Student

–使用默认方式删除数据库

drop database Student

–创建数据库，并指定相关信息，逻辑文件名，物理文件名，初始容量，最大容量及数据增长比例

create database Studentinfo
on
(name=student_dat,filename='d:\data\student_dat.mdf',size=10,maxsize=50,filegrowth=5)
log on
(name='student_log',filename='d:\data\student_log.ldf',size=10,maxsize=50,filegrowth=5)

–修改数据库

alter database Studentinfo
/*add file(name=student_dat1,filename='d:\data\student_dat.ndf',size=10,maxsize=50,filegrowth=5)  --增加新的.ndf文件
*/
remove file student_dat1

-------------------------------------------------数据表操作-----------------------------------------------
–创建表

use Studentinfo
go
create table basicinfo(
  s_id char(11),
  s_name varchar(10),
  s_phone char(11)
)

–修改表

alter table basicinfo
add s_gender char(2)
--修改列
alter table basicinfo drop column s_phone

–查看表

select * from basicinfo

–删除表

drop table basicinfo

-------------------------------------------------数据记录操作-----------------------------------------------
–向表中添加数据

use Studentinfo
go
insert into basicinfo
values('17034002154','林顺','男')

insert into basicinfo(s_name,s_id)
values('caole','1802545221')

–修改记录

update basicinfo
set s_name='linshun'
where s_id='17034002154'

–删除记录

delete
from  basicinfo
where s_id='17034002154'