SQL Server如何创建数据库

1. 创建数据库

use master
go
--创建数据库
create database StudentManageDB
ON primary
(
name  = 'StudentManagementDB_data',--数据库文件的逻辑名
filename = 'D:\Program File\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\StudentManagementDB_data.mdf',--数据库物理文件名（绝对路径）
size=10MB,--数据库文件初始大小
filegrowth=5MB--数据库扩充，数据文件增长量
)
log on 
(NAME = 'StudentManagementDB_log',
filename='D:\Program File\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\StudentManagementDB_log.ldf',
size = 5MB,
filegrowth = 2MB
)
go

2. 判断数据库是否存在并删除数据库

if exists(select * from sysdatabases where name = 'StudentManageDB')
drop database StudentManageDB