--创建数据库
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
标签:复习,database,--,filegroup,file,MYSQL,FILEGROUP,name From: https://www.cnblogs.com/YueJinqiu/p/17437965.html