MySQL数据库T-SQL语言

创建数据库和日志文件

CREATE DATABASE STUDENT
ON PRIMARY
(
NAME = STUDENT_DAT2,
FILENAME = 'D:\STUDENT\STUDENT_DAT2.mdf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH = 1MB
)

LOG ON 
(NAME=STUDENT_log2,
FILENAME='D:\STUDENT\STUDENT_LOG2.ldf',
SIZE = 2MB,
MAXSIZE = 10MB,
FILEGROWTH=10%
)

添加数据库扩展文件

alter database STUDENT
ADD FILE
(
NAME =sample_dat2,
filename='d:\STUDENT\sample_dat2.ndf',
size=4,
maxsize=10,
filegrowth=1
)

修改数据库数据

alter database STUDENT
MODIFY FILE
(
NAME=sample_dat2,
size=10mb,
maxsize=80mb,
filegrowth=5mb
)

查看数据库属性

sp_helpdb @dbname="***"

删除数据库

drop database dbname
例如：
drop database school

分离和附加

分离：

exec sp_detach_db student


附加：

exec sp_attach_db @dbname="textstudent",

@filename1 = "d:\textstudent\student_dat.mdf",

@filename2 = "d:\textstudent\student_dat_log.ldf"

压缩数据库

dbcc shrinkdatabase (数据库名，压缩率)