1.最简单的创建数据库SQL语句
create database database_name;
2.修改数据库的SQL语句(以MS SQL Server为例)
alter database database_name
{
add file <filespec> [,...n] [to filegroup filegroup_name]
| add log file <filespec> [,...n]
| remove file logical_file_name [with delete]
| add filegroup filegroup_name
| remove filegroup filegroup_name
| modify file <filespec>
| modify name=new_dbname
modify filegroup filegroup_name
{filegroup_property | name = new_filegroup_name}
| set <optionspec> [,...n] [with<termination>]
| collate <collation_name>
}
3.删除数据库的SQL命令
drop database database_name[,...n]