SQL 2012 语言

create database nn

create database jx

on primary

(name=jx1,

filename='d:\jx1.mdf',

size=10,

maxsize=100,

filegrowth=2),

(name=jx2,

filename='d:\jx2.ndf')

log on

(name=jx1_log,

filename='d:\jx1_log.ldf')

create database cs

on primary

(name=cs1,

filename='d:\cs1.mdf'),

filegroup csg

(name=cs2,

filename='d:\cs2.ndf')

修改数据库(alter)

1.给jx 数据库添加一个数据文件jx3

alter database jx

add file

(name=jx3,

filename='d:\jx3.ndf',

size=10,

maxsize=unlimited,

filegrowth=20%)

2.给jx数据库添加日志文件jx2_log

alter database jx

add log file

(name=jx2_log,

filename='d:\jx2_log')

3.给jx数据库添加文件组jxg

alter database jx

add filegroup jxg

4.给jx数据库jxg文件组添加文件jx4

alter database jx

add file

(name=jx4,

filename='d:\jx4.ndf') to filegroup jxg

5.删除数据文件jx3,jx2,问jx1能否删除(remove)

alter database jx remove file jx4

6.删除文件组jxg，问主文件组能否删除

alter database jx

remove filegroup jxg

drop database jx use nn

create table s

(sno char(8) constraint sno_p primary key,

sn varchar(10) not null,

sex char(2) default '男',  

age tinyint,  

dept varchar(50) )  

create  table c  

(cno char(10) primary key,  

cn varchar(50))  

create table sc

 (sno char(8) not null foreign key references s(sno),  

cno char(10) not null foreign key references c(cno),  

score numeric(4,1) check(score>=0  and score<=100),

 primary key(sno,cno))

 

转载于:https://www.cnblogs.com/hupolinglong/articles/sql2012.html