创建数据库
CREATE DATABASE test01
on
(
name = 'test01',
filename = 'd:\software\sql sever 2019\install\mssql15.mssqlserver\mssql\data\test01.mdf',
size = 8mb,
maxsize = 20mb,
filegrowth = 1mb
)
log on
(
name = 'test_log',
filename = 'd:\software\sql sever 2019\install\mssql15.mssqlserver\mssql\data\test01_log.ldf',
size = 8mb,
maxsize = 20mb,
filegrowth = 1mb
)
删除数据库
drop database 数据库名