MYSQL复习

--创建数据库
CREATE DATABASE database_name
ON [PRIMARY]
(
NAME = file_name,
FILENAME = 'os_file_name',
[SIZE = size,]
[MAXSIZE = max_size | UNLIMTED,]
[FILEGROWTH = growth_increment]
)
LOG ON [PRIMARY]
(
NAME = logical_file_name,
FILENAME = 'os_file_name',
[SIZE = size,]
[MAXSIZE = max_size | UNLIMITED,]
[FILEGROWTH = growth_increment]
)
GO

USE database;
--修改数据库
ALTER DATABASE database_name
--添加文件
ADD FILE<filespec> [TO FILEGROUP file_name] 
| ADD LOG FILE <filespec>
| REMOVE FILE logical_file_name
| MODIEY FILE
| ADD FILEGROUP filegroup_name
| REMOVE FILEGROUP filegroup_name
| MODIFY FILEGROUP filegroup_name
| MODIFY FILEGROUP filegroup_name
| MODIFY FILEGROP filegrop_name filegroup_name {filegroup_properte | NAME = new_filegrouo_name}

-- 创建数据表
USE database;
CREAT TABLE table_name(
    column_name<data_type>[NULL | NOT NULL] [CONSTRAINT constraint_name PRIMARY KEY [CLUSTERED | NOTCLUSTERED]]-- 主键
　　　　　　　　　　　　　　　　　　　　　　　　　　 [CONSTRAINT constraint_name FOREIGN KEY REFERENCES referenced_table_name]
);

-- 修改数据表
ALTER TABLE TABLE_NAME
{[ALTER COLUMN clumn_name 
new data type NULL | NOTNULL]}
| ADD | DROP
　　colum_name<data_type>

-- 分离用户数据库
USE master
GO 
EXEC sp_detach_db [@dbname =] 'database_name'
[, [@skipchecks = ]'skipchecks']
[, [@keepfullextindexfile = ]'keepfullextindexfile']
GO