tsql操作数据库:
1:打开数据库:use test1
2:查看数据库信息
exec sp_helpdb database_name
3:修改数据库容量
4:更改数据库名称
ALTER DATABASE student44 SET SINGLE_USER; //修改成单用户状态
exec sp_renamedb 'mytest1', 'mytest' //重命名数据库
ALTER DATABASE mytest SET MULTI_USER ; /修改回多用户状态
5:分离和附加数据库
分离:exec sp_detach_db 'student44'
附加:create database student44
on(filename = 'D:\data\student_Data.mdf')
for attach
6:删除数据库
drop database student44
7:课堂任务参考答案:[题目参考第六次课ppt]
CREATE DATABASE student66
ON PRIMARY
(NAME = 'student_Data',
FILENAME = 'D:\data\student66.mdf',
SIZE = 3MB,
MAXSIZE = 20MB,
FILEGROWTH = 20%),
(NAME = student_Data2,
FILENAME = 'D:\data\student66.ndf',
SIZE = 3MB,
MAXSIZE = 20MB,
FILEGROWTH = 20%)
LOG ON
(NAME = student_log,
FILENAME = 'D:\data\student66.ldf',
SIZE = 1MB,
MAXSIZE = 10MB,
FILEGROWTH = 10%)