Navicat
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 test01;
create database teach
on
( name=teach_data,
filename='D:\operation\teach.mdf',
size=2,
maxsize=10,
filegrowth=1 )
log on (
name=teach_log,
filename='D:\operation\teach.ldf',
size=2,
maxsize=10,
filegrowth=1 )