use master
go

if exists(select name from sysdatabases where name=N'db_student')
drop database db_student

create database db_student
ON primary

(name=N'db_student_Data',
filename=N'D:\Program Files\Microsoft SQL Server\MSSQL\Data\db_student_data.mdf',
size=30720kb,
maxsize=unlimited,
filegrowth=10%)

log on
(name=N'db_student_log',
filename=N'D:\Program Files\Microsoft SQL Server\MSSQL\Data\db_student_log.ldf',
size=1024kb,
maxsize=unlimited,
filegrowth=10%)
collate Chinese_PRC_CI_AS
go