1.执行SQL文件快捷键 F5
2.创建数据库语句
cteate datebase book
on primary
(name=book_date,
filename='d:\book.mdf',
size=55,
maxsize=120,
filegrowth=10%)
log on
(name=book_log,
filename-'d:\book.ldf',
size-12,
maxsize=30,
filegrowth=3)
3.修改数据库(数据库扩容)
alter database book
modify file
(name='d:\book.mdf',
size=60
)
4.缩减数据库
dbcc shrinkdatabase(batabase_name[,new_size['masteroverride']])
dbcc shrinkdatabase('book')---将book数据库的空间缩减至最小容量
5.将book数据库设置为只读状态
exec sp_dboption 'book','read only',true
6.数据库更名
exec sp_renamedb 'book','shu'
7.删除数据库
drop database book
8.自定义数据类型
exec sp_addtype meetingday,samlldatetime,'not null'----创建
exec sp_droptype 'meetingday'----删除
9.删除约束
alter table table_name
drop constraint constraint_name
10.增加列
alter table book
add author varchar null
11.删除列
alter table book
drop column author
12.修改列的数据类型
alter table book
alter column price smallmoney
13.查看表的结构信息
exec sp_help table_name
14.删除数据
delete from book where price=10000----删除一列
delete from book----删除全部数据
drop table table_name----删除表
15.check约束
alter table book
add
constraint ck_book check(性别='男' or 性别='女')----添加约束
alter table book
drop constraint ck_book
16.default约束的创建、查看和删除
alter table book
add constraint 性别 default '男' for 性别----添加约束
alter table book
drop constraint de_性别
17.primary key的创建、查看和删除
alter table book
add comstraint pk_作者编号 primary key clustered(作者编号)----添加pk
alter table book
drop constraint pk_作者编号
18.foreign key的创建,查看和删除
alter table book
add comstraint pk_作者编号 primary key clustered(作者编号)----添加pk
alter table bookin
add constraint fk_作者编号 foreign key(作者编号)
references book(作者编号)
19.使用默认default
use book
go
create default mr_定价
as '100'
go----创建默认值
exec sp_bindefault mr_定价,'book.定价'----绑定
20.规则的使用
use book
go
create rule gz_定价
as @定价>=0 and &#